SQL 2005 Data Transformation Services

[szlamany]

I'm just helping a customer migrate some DTS jobs from SQL 2K to 2005.

These are simple jobs that run some .bat files, .exe files and a couple that run sprocs. All of these run in the AGENT on SQL 2K.

Why is DTS under LEGACY in Management studio?? Is that not the way jobs like this are supposed to be created in 2005?

Any help would be greatly appreciated - thanks!

[kaffenils]

DTS has been replace by SSIS (SQL Server Integration Services). You can still run DTS packages, but there is a chance that DTS will be removed in future versions.

You create SSIS packages using either Business Intelligence Development Studio (found in SQL Server 2005 on Start->Programs) or by using Visual Studio .Net

You import SSIS packages into SQL Server by connecting to the SSIS instance onthe server. This is done by using SSMS. Click the Connect buttons drop down icon and select SQL Server Integration Services from the drop down list. Import and schedule SSIS packages from here.

[szlamany]

Thanks for the quick answer!