Post reply

Importing DTS from SQL Server 2000 to SQL Server 2005

  • September 24, 2004 at 3:47 am

    #162821

    Hi,

    Does anyone sucessfully imported a DTS stored in SQL Server 2000 into SQL Server 2005?

    Thanks in advance.

  • September 26, 2004 at 10:57 pm

    #524445

    I dont have expereince in doing this. but from what I saw of the SQL Server 2005 DTS package you will not be able to map one-to-one of these packages. The architecture has changed drastically. But having said that, I saw a wrapper job in DTS2005 that can execute DTS2000 packages. Did you even try to explore that?

    Vinod Kumar

    http://www.ExtremeExperts.com

  • September 27, 2004 at 2:03 pm

    #524574

    I'm anxiously awaiting to test this myself.  We have to wait for the public release of the Yukon Beta, but I would hope Microsoft would give us something to run all of our 2000 DTS packages in Yukon since we have so many!

  • September 28, 2004 at 6:13 am

    #524609

    I did a quick work for this and found you can indeed call the DTS 2000 packages from SQL 2005 DTS using the "Execute DTS 2000 Package Task Editor". The config for the same is very very simple and looks like:

    DTS 2000 Package execution in Yukon

    The config is very very simple and easy to execute ...

    HTH,

    Vinod Kumar

    http://www.ExtremeExperts.com

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

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