Chapter 7. Understanding SSIS Connectivity

SSIS is used as a universal platform for performing extract-transform-load (ETL) operations for data sourced from heterogeneous data sources. This is because SSIS doesn’t centrally own or manage any specific connectivity option or technology. Rather, because it uses an extensible object model, SSIS can be easily extended to support a specific connectivity technology or data vendor. This flexibility has resulted in SSIS being interoperable with a multitude of available connectivity options. However, with such a large number of ...

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.