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

5 pts.
Tags:
Copy Database Wizard
SQL Server 2005
SSIS
Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard". 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following