O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required