Post reply

Upgrate SQL 2000 DTS to SQL Server 2005

  • July 12, 2009 at 2:58 pm

    #136165

    Hi all,

    I finished from upgrade my SQL 2000 cluster to SQL server 2005 but my issue now is the DTS , all DTS will work as it is now after upgrade and will not migrate to SSIS my question is how can i use this DTS if I want to execute or edit

    I download and setup SQL Server 2000 DTS designer component but i don't know how can i used

  • July 12, 2009 at 4:15 pm

    #1023651

    No need to install SQL Server 2000 DTS designer components on your Cluster.

    If want to see and edit the DTS package, intall SQL Server 2000 DTS designer component in Development server->open the DTS package and do the necessary modifications and save that package to the clustered SQL Server.

  • July 12, 2009 at 5:53 pm

    #1023660

    I'd really recommend that you begin learning SSIS and rewriting these packages.

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

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