Tag Archives: msdb database

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

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