Chapter 2. Understanding SSIS Concepts

As discussed in Chapter 1, Microsoft SQL Server 2012 Integration Services is a comprehensive platform for data integration applications. When the product was first released in SQL Server 7.0, however, Integration Services was only a simple extract–transform–load (ETL) utility called Data Transformation Services (DTS). Over the years Microsoft added numerous features into the product; in addition, the product architecture has been altered considerably so it can host modern data integration applications. As a result, Integration Services has become increasingly powerful, while becoming more and more complicated. Before going deeply into the discussions ...

Get Microsoft® SQL Server® 2012 Integration Services 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.