Hello:

We are moving data fronm a SQL 2000 server to a SQL 2005 server. How do you
copy DTS package files from one SQL server to another? Can you right-click
on the package files on the 2000 box and export the packages to a file for
transferring to the 2005 box or something along those lines?

childofthe1980s

In SQL Server 2005, DTS has been replaced by SQL Server Integration Service.
However, you can still be able to export DTS packages from SQL Server 2000 to
SQL Server 2005 (just as you've mentioned), provided that you installed the
Feature Pack for SQL Server 2005, which includes the Microsoft SQL Server
2000 DTS Designer Components. It can be found on:
http://www.microsoft.com/downloads/d...displaylang=en

If you want to migrate your DTS from SQL Server 2000 onto SSIS in SQL Server
2005, the following article talks about it:
http://www.microsoft.com/downloads/d...displaylang=en

You don't have to convert your DTS into SSIS package in SQL 2005 since you
can run DTS in SQL 2005, but you might want to consider it.


"childofthe1980s" wrote:

Oopss. Sorry, here's the article on DTS to SSIS migration:
http://www.simple-talk.com/sql/sql-s...sis-migration/

"Lucas Kartawidjaja" wrote: