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