Used Migration Wizard To Migrate DTS Packages To 2005

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

--
04 Dec 2007 06: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?
SQLUSA
New Member
New Member

--
04 Dec 2007 06: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 - http://www.sqlusa.com/order2005ssis/



Acceptable Use Policy
---