October 2011
Intermediate to advanced
688 pages
24h 5m
English
Tim Mitchell
The data flow workspace in SQL Server Integration Services (SSIS) is packed full of useful source, transformation, and destination components that can be used to address the most common extract, transform, and load (ETL) data challenges. But anyone who works in this space for long will quickly discover that some ETL problems don’t fit neatly inside those little boxes. Fortunately, SSIS includes a flexible and powerful tool for handling custom data flow needs: the SSIS Script component.
The SSIS Script component is, as the name suggests, a scripting interface within Integration Services that allows the direct inclusion of custom code within a data ...
Read now
Unlock full access