Main Content

In-Depth with the SSIS Script Task

A talk by Todd McDermid

About the Talk

November 4, 2010 9:00 AM

Date/Time TBA The Script Task is the Swiss Army knife of Integration Services process orchestration. It’s rare to be able to construct a real-world ETL solution with only the tools provided with the built-in SSIS tasks. When no task in the toolbox can accomplish what you need, then the Script Task is a powerful alternative. Scripts have easy access to SSIS variables and connections, and have the full power of the .Net Framework behind them. But scripting in Integration Services isn’t all unicorns and rainbows. Knowledge of C# or VB.Net is essential even for very basic operations, and restrictions placed on the Script for the privilege of operating within the SSIS control flow must be understood. This session will educate attendees on how to get results quickly with the Script Task, focusing on common problems it’s being used to solve in the real-world.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus