[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 461
  • Last Modified:

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?

  • 2
1 Solution
Check if the dts packages exist in the server..

use msdb
select * from sysdtspackages
johnftamburoAuthor Commented:
Hi.  The query returns no rows.
After migrating packages from within Management Studio, connect to the local instance of Integration Services in Object Explorer to see the migrated packages. If you selected SQL Server as the destination, the migrated packages will be visible under the MSDB node. If you selected a file system folder as the destination, right-click the File System node and select Import Package to display the migrated packages. After migrating packages from within BI Development Studio, the migrated packages are saved to the file system folder that you specified and added to the open project under the SSIS Packages node

Source: http://msdn2.microsoft.com/en-us/library/ms143496(SQL.90).aspx

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now