SSIS SQL Server Deployment, File System Deployment, and SSIS Package Store

SSIS packages can be stored in file system, as well as SQL Server. Let’s have a look at each one of these options for storing our SSIS packages. 1- SQL Server: When a package is deployed to SQL Server, it is actually stored in MSDB database. The easiest way to deploy a SSIS package to … Continue reading SSIS SQL Server Deployment, File System Deployment, and SSIS Package Store

Changing a Connection Manager’s Conenction String using C# – SSIS 2008

A SSIS package can be run using C#, or basically any CLR language. The piece of code depicted in the following image calls a package, tries to execute it, and prints any error or exception that occurs dutring execution of the package to output: Simple and easy! Now suppose our package has 2 connection managers: … Continue reading Changing a Connection Manager’s Conenction String using C# – SSIS 2008

SQL Server 2000 stored procedure and SSIS 2008 OLE DB Source

What is the first thing that comes to your mind as a Microsoft BI expert, when you think of a data migration tool? Undoubtedly SSIS! As you all know, SSIS is a great tool for migrating data from legacy systems and databaseas into newer and more robust places and repositories to better serve knowledge and … Continue reading SQL Server 2000 stored procedure and SSIS 2008 OLE DB Source