Tag Archives: SSIS 2008

Deploy SSIS Packages across servers

Background Recently I had to deploy a set of SSIS packages stored in the msdb of a development server into a test server. I should mention that a SSIS package could be stored in the file system, in a package … Continue reading

Posted in Business Intelligence, SQL Server | Tagged , , , | 3 Comments

Store file names and modified dates in a table without a Foreach Loop Task – SQL Server – SSIS

Last week I received a request from the project manager. I had to improve the performance of an SSIS package that reads a collection of files from a source folder, and then stores their name, extension, location and modified date. … Continue reading

Posted in Business Intelligence, SQL Server | Tagged , , , , | 5 Comments

Read and Write variables in a Script Component in SSIS (SQL Server Integration Services) using C#

The Script Component is a SSIS Data flow component and it differs from the Script Task in a Control Flow. It has some limitations to read and write values from package or data flow task level variables. There is more than … Continue reading

Posted in Business Intelligence | Tagged , , , , , | 5 Comments

Manage packages stored in the MSDB database with T-SQL

Last week we’ve performed a typical migration from a development server to a production server. Both servers are running SQL Server 2008 R2 databases. I created a set of SSIS ETL packages and I wanted to move them to production … Continue reading

Posted in Business Intelligence | Tagged , , , , , , , , , | Leave a comment