Question

How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

SQL Server 2005, SSIS, Copy Database Wizard

Hello,

I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard" at http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html.

Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I can't find out how to modify the SSIS package that the wizard created. It seems to be internal to SQL Server.

How do I get to an internal (not saved on disk) SSIS job? If I can't do that, how can I set the order of the copying of the databases?

Thanks!

Paul

If you selected the Save Package option at the end of the wizard you can import that package into a BIDS project and then edit it.

If you saved the package to the SSIS server you'll need to export the package first. Connect to the SSIS server with Management studio. In the Object explorer select the connect menu and select Integration Services. Then enter your SQL Server's name and hit connect. In the object explorer navigate to where the package is, and you should be able to right click on it and select export.

Then open BIDS (Business Intelligence Development Studio) and create a new Integration Services project. In the object explorer on the right, right click on Packages and select add existing. Now navigate to your existing package and select open. You'll now see if listed to the right. Double click it to open it and you can now edit the package. After you are done editing the package you can either run it from BIDS, or you can import it back into the SQL Server so that you can run it scheduled.