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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.