SQL Server 2005 includes a redesigned enterprise data extraction, transformation, and loading (ETL) platform, called SQL Server Integration Services (SSIS), which replaces DTS 2000.
SSIS (SQL Server Intergration Services) has some new features:
- Business Inteligence Development Studio (BIDS) for creating DTS packages
- SSIS packages can be saved as XML .
- .Net languages can be used for creating SSIS components.
- SSIS allows FTP in/out
- SSIS has new comand line tools(DTSExec replaces DTSRun, DTSExecUI replaces DTSRunUI, DTSUtil).
- And more…