Chapter 6. Integration Services
SQL Server Integration Services (SSIS) has come a long way. In the early days of SQL Server, the only data transfer facilities available were BCP and SQL Server Transfer Manager. The former is a useful command-line utility still with us today, while the latter was superseded in SQL Server 7.0 by Data Transformation Services (DTS)
While DTS was a definite improvement, it had shortcomings that were difficult to work around. Complex DTS packages were difficult to work with, control flow was tied together with data flow and redeployment was a difficult experience.
In SQL Server 2005, Microsoft released the first version of the Integration Services we know and love today. Seven years on, with SQL Server 2012, SSIS has ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
