C H A P T E R  10

Scripting

You’re darn right more power!

—Tim Allen, Home Improvement

SSIS provides several stock control flow tasks and data flow components out of the box, all described in the previous chapters. Despite all these great tools, you’ll inevitably encounter a situation when you need to do something that’s not covered by the stock toolkit. The Script task and script component are two tools that give you an extra power boost. With the Script task and script component, you can use .NET code to enhance your SSIS packages and to manipulate and transform your data in ways the stock components can’t.

Script Task

SSIS comes with more than 20 stock control flow tasks that perform a variety of functions. Whether you need to put or get ...

Get Pro SQL Server 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.