johnftamburo
asked on
SQL 2005 Management Studio DTS 2000 migration says "success" but packages not visible in Mgmt Studio
Hi. I ran management studio, legacy, and migrated 44 DTS packages from SQL 2000 to 2005. Wizard says success but packages are not visible in the studio. If I try th4e migration again, wizard says they're already there.
Can anyone help?
Thanks
John
Can anyone help?
Thanks
John
ASKER
Hi. The query returns no rows.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
use msdb
select * from sysdtspackages