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 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.
