O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

The Script Task

The Script task allows you to add manually written business logic into the control flow. Let’s take a closer look now at exactly how this task works.

To get started, create a new SSIS package in Business Intelligence Development Studio (BIDS). Drag the Script Task from the Toolbox onto the designer surface. After you have dropped the appropriate object on the control flow surface, double-click on the newly created Script Task box to open the Script Task Editor dialog box. Note that the default scripting language is C#. Alternatively, you can write your SSIS scripts in Visual Basic .NET. The language type is configured at the level of each Script task using the ScriptLanguage property. Once you have begun editing the script, you ...

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