SQLBits,SSIS - Sparks from the Anvil

Browse by Tags

All Tags » SQLBits » SSIS (RSS)

SSIS: Building SQL databases on-the-fly using concatenated SQL scripts

Over the years I have developed many techniques which help automate the whole SQL Server build process. In my current process, where I need to build entire OLAP data marts on-the-fly , I make regular use of a simple but very effective mechanism to concatenate...
Posted by DrJohn | 2 comment(s)
Filed under: , ,

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 | 2 comment(s)

Building dynamic OLAP data marts on-the-fly

At the forthcoming SQLBits conference , I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly...
Posted by DrJohn | 3 comment(s)