CODEWITHSUNDEEP
ssissql-server-2008-r2sql-server-2000dts
user2537249
user2537249

Reputation: 41

Run DTS packages against SQL Server 2008R2

We have an old SQL server 2000 server hosting many DTS packages and all these packages were pushing data into a SQL Server 2005 database hosted on a different windows box. We are now planning to migrate this sql 2005 box to SQL server 2008r2. So, the dts packages would start dumping data into the new sql server 2008r2 server. With this scenario do we need to upgrade the DTS packages to SSIS or can we continue with existing setup and just push data from windows 2000 server (hosting DTS packages) to the SQL server 2008r2

Thanks

Upvotes: 1

Views: 1888

Answers (1)

Kin Shah
Kin Shah

Reputation: 612

IMHO, its better to migrate to SSIS to have better support.

You have to use DTS Package Migration Wizard which ships with SQL Server 2008.

If you want to look at some 3rd party tools, then DTS xChange is the best out in the market. Its costly - 20 Conversions for $900.

Upvotes: 1

Related Questions