Used Migration Wizard To Migrate DTS Packages To 2005

Last Post 04 Dec 2007 05:44 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

04 Dec 2007 05:23 AM
I used the SQL2005 DTS Migration wizard to migrate some SQL2000 packages. The process finished successfully but now I can't "find" the packages. Where are they?
New Member
New Member

04 Dec 2007 05:44 AM
If you used Business Intelligence Development Studio, they should be in the project which was open at the time.

If you used Management Studio, you have to open SSIS Object Explorer and drill down.

In Registered Servers right click on the last icon (SSIS), register your IS server if not registered, otherwise connect to Object Explorer.

Go to Object Explorer window and drill down.

Kalman Toth, Business Intelligence Architect
SQL Server 2005 Training -

Acceptable Use Policy