Summary
SSIS provides you with an incredible degree of flexibility and power when implementing your ETL solution. This chapter covered the foundations of using the tools available in BIDS to create the SSIS packages that will be the workhorses of your ETL processes for BI. You learned more about common objects—data sources and DSVs—and then explored connection managers. The heart of this chapter covered the core of the ETL toolset—control flow task and data flow transformations. You also learned about using the Dynamic Package Configuration Wizard.
Believe it or not, there is still much more to learn about creating data workflows using SSIS. In Chapter 9, we'll explore debugging, error handling, event handling, logging, and using transactions ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
