Chapter 19. Extending and Integrating SQL Server 2008 Integration Services
As we discovered in previous chapters, SQL Server Integration Services (SSIS) gives us a lot of power and flexibility right out of the box. With dozens of tasks and components ready to use, a lot of the typical work in an extract, transform, and load (ETL) phase can be done by just dragging and dropping objects, and configuring them appropriately. But sometimes these included tasks are just not enough, particularly because business requirements or data transformation logic can get complex.
SSIS provides an answer even to these demanding requirements we find in business intelligence (BI) projects. This answer lies in using very powerful scripting support that allows us to ...
Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 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.
