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