O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 51. Extending SSIS using the Script component

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 Swiss Army knife of SSIS

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required