DTS migration from 2k to 2005

  • In the

    http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    at Microsoft SQL Server 2000 DTS Designer Components it says that

    "After installing this download, SQL Server 2005 users can continue to edit and maintain existing DTS packages from the Object Explorer in SQL Server 2005 Management Studio"

    I was tring to find how can you do it from there but haven't find yet. Does anybody knows how to do it?

  • Your legacy DTS packages (those not upgraded to SSIS) are in Management/Legacy/Data Transformation Services.  Once you have the Microsoft SQL Server 2000 DTS Designer Components  installed, just right click on the legacy package and click open.

  • I installed the Microsoft SQL Server 2000 DTS Designer Components  , I can edit the packages via Visual Studio (Execute TDS 2000 Packages), I can see the packages on Object Explorer\Integration Services\Stored Packages\MSDB but they are not showing up under Legacy.

    Any idea?

  • It sounds like you used the DTS to SSIS migration tool on your packages.  It has been my experience that this tool will attempt to convert your packages and any part which can't be converted will be converted into a separate DTS package and called from the new SSIS package.  If your packages are showing up in the SSIS area then you probubly ran the upgrade utility.

    I am in the middle of my first migration to SQL2005 right now so I am learning all this right along with you.  I am hoping to import all my jobs to the legacy area and run them from their until I get time upgrade them to SSIS.  I haven't yet had a successful run but hopefully I will soon.

    BTW, to amend what I said above reguarding opening legacy DTS packages.  That is the method which MS says should work, however I have only gotten errors so far when trying to open the legacy packages.

  • You are right, I used the migration utility.

    I exported the 2k DTS package as a dts file, imported into Legacy, and now I can open it, no error.

    Thanks

  • I would like to install the Microsoft SQL Server 2000 DTS Designer Components on a 64 bit platform (SQL 2005), the one offered at http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en is referred to as x386.  Is the download good for SQL Server 2005 Standard 64 Bit Edition or only 32 Bit?

     

  • I personally haven't done anything with SQL 2005 64 bit, but I doubt it would be that hard to install it on a workstation for a quick test which should be done anyway before you try it on a server.

Viewing 7 posts - 1 through 7 (of 7 total)

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