Summary

We've now completed our tour of SSIS. From simple tasks, like using the Import/Export Wizard to quickly move data between a source and a destination, to complex transactional data workflows, SSIS really does it all. SSIS is an invaluable tool for implementing BI solutions.

In the next chapter, we will begin our exploration of reporting tools. Our first stops will be SQL Server Reporting Services (SSRS) and Report Builder 3.0.

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.