Does SQL Server 2005 have a DTS replacement?

[rodeomount]

I'm in the process of switching from SQL Server 2000 to 2005. I know that Management Studio has Replaced Enterprise Manager. Is there a ubstitute for DTS?

 

[RiverGuy]

Yes, and it is called SQL Server Integration Services (SSIS). It is more of a full-featured ETL tool than DTS, and the learning curve is probably a bit higher.

 

[fredericofonseca]

And it requires a new license. Some of the SQL Server editions do not have it by default.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com