DTS Packages

Hi,

I want to know what are DTS packages, how are they used, and the benefits.

Do DTS packages still exist in SQL 2005?

Thanks

SQL 2005 has replaced DTS with Integration Services. It is a totally new paradign and the previous DTS packages are not compatible.

You can get a lot of information for either at:

www.sqldts.com

www.sqlis.com

Also, Look in Books Online for more information, DTS in SQL 2000, SSIS in SQL 2005.

|||

DTS is the ETL tool available in SQL Server 7 and 2000

http://vyaskn.tripod.com/sql_server_dts_best_practices.htm

In SQL Server 2005 , DTS been replaced by SQL Server Integration Services (SSIS) which is a complete, feature rich,control rich ETL tool. there are many enhancement in SSIS. DTS is still suppored by SQL Server 2005 for backward compatibility , but it is not recommended for new development..

Madhu

|||Yes, they still exist. They've changed format, however. You can convert DTS packages from SQL Server 2000 into SQL Server Integration Services packages. Or, you can continue to run the old packages. SQL Server Integration Services is far richer than DTS was, so packages can't be converted from SSIS back to DTS.

You can read lots more about SSIS in the SQL Server Integration Services section of this site.