SQL 2005 Management Studio DTS 2000 migration says "success" but packages not visible in Mgmt Studio

Posted on 2006-03-23
Last Modified: 2013-12-03
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?

Question by:johnftamburo
    LVL 20

    Expert Comment

    Check if the dts packages exist in the server..

    use msdb
    select * from sysdtspackages

    Author Comment

    Hi.  The query returns no rows.
    LVL 20

    Accepted Solution

    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


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now