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.
SSIS comes with more than 20 stock control flow tasks that perform a variety of functions. Whether you need to put or get ...