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.