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

Are you beginning to understand the power of SSIS? This component of SQL Server is incredibly flexible and important to all BI solutions. We've covered only the basics of using the tools available (either in SSMS, with, the SQL Server Import and Export Wizard or in BIDS, with the SSIS Integration Services project type template) to create SSIS packages that will be the workhorses of your ETL processes for BI.

We've really just scratched the surface of what is possible with SSIS. In Chapters 8 and 9, we'll explore the data flow transformations and control flow tasks in greater depth. Also, you'll learn about error handling, debugging, and best practices for SSIS design in BI projects.

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