Post reply

Cannot find the DTS package after saved it within SQL2005...Please HELP!!!

  • February 6, 2007 at 9:44 am

    #116109

    We are in the process of migrating from SQL2K to SQL2005. Problem is when I save a DTS package using SQL 2005 import wizard, I can't find it anywhere in the Management Studio. Can someone please help me out on this?

    Thanks a lot!

    - Syed

  • February 6, 2007 at 10:03 am

    #688103

    Look under Management, Legacy, Data Transformation Services.  It should be there.

  • February 6, 2007 at 10:25 am

    #688109

    john,

    Only DTS packages that converted from SQL 2000 can be found in the Legacy --> Data Transformation Services area. Can't find the one I just created using SQL 2005 Import wizard. However, I can now see the packages when I go to SQL Server Agent --> Jobs --> Steps --> New Task --> Select Packages. I just found out this but still couln't find the SQL 2005 Local Package Storage.

    Thanks for your quick response though.

    - Syed

      

     

  • February 6, 2007 at 2:22 pm

    #688144

    Hi.. Did you try connecting through intergration services in SSMS? Under registered servers click on the "intergration" button (the one on the right) and then connect to your server.. they should show up there under stored packages..

    Thanks..

    Rich

  • February 7, 2007 at 12:04 pm

    #688366

    How would you "edit" the package under sql2005?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply