Microsoft® SQL Server 2012 Unleashed

SSIS Architecture and Concepts

You can think of SSIS as a data import/export/transformation layer in the overall system architecture that you are deploying for at least most of your Microsoft-based applications and a few non-Microsoft applications (see Figure 54.5). SSIS allows you to “data enable” almost all the individual applications or systems that are part of your overall implementation, such as OLTP databases, multidimensional cubes, data warehouses, Excel files, Access databases, flat files, other heterogeneous database sources, and even XML and web services. The Integration Services object model includes both native and managed APIs for doing most SSIS work. This includes APIs for any of the SSIS tools, the command-line utilities, and ...