Browse by Tags

All Tags » C# (RSS)
07 February 2011 18:07

SSIS: Deploying OLAP cubes using C# script tasks and AMO

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP...
Posted by DrJohn | 1 comment(s)
Filed under: , , , ,
23 April 2008 14:17

SSAS Stored Procedures - connecting to the transactional data source

There are often circumstances where an SSAS stored procedure needs to connect to the transactional database to perform a query. This is certainly the case in a near-real-time OLAP solution where the cube sits directly on top of the application database...
Posted by DrJohn | 1 comment(s)
Filed under: ,
02 November 2007 08:53

Converting C# to VB.NET for use in SSIS

If you much prefer C# over VB.NET but are forced to use VB.NET as that is the only language supported by SSIS, you will love the tool I discovered. Some cool guys over at DeveloperFusion have created an on-line C# to VB.NET convertor which makes the transition...
Posted by DrJohn | 2 comment(s)
Filed under: ,