SQL Server Integration Services
SQL Server Integration Services is an all-new subsystem for SQL Server 2005. With SQL Server 2005 Microsoft has replaced the old Data Transformation Services (DTS) with the all-new SQL Server Integration Services (SSIS). It’s important to understand that SSIS isn’t a reworked version of DTS. Instead, Microsoft rewrote SSIS from the ground up. Microsoft’s goal for SQL Server 2005’s Integration Services was to make it an enterprise ETL platform for Windows on a par with any of the stand-alone enterprise-level ETL products. The new SSIS is completely redesigned and built using managed .NET code, giving it a more robust foundation.
[Read the rest of this entry...]
