Link to home
Start Free TrialLog in
Avatar of johnftamburo
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
Avatar of Sirees
Sirees

Check if the dts packages exist in the server..

use msdb
select * from sysdtspackages
Avatar of johnftamburo

ASKER

Hi.  The query returns no rows.
ASKER CERTIFIED SOLUTION
Avatar of Sirees
Sirees

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial