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 Component

Now that we’ve taken a look at how you can use the Script task in the control flow, we’ll turn next to using the Script component in a data flow. Here you’ll see how you can leverage the power of scripting while processing data.

To take a closer look at the Script component, you need to drag one Data Flow task onto your sample package’s designer surface from the Toolbox. Double-click the Data Flow task to open the data flow in design view. Next, select the Script Component from the Toolbox and drop it onto the data flow designer surface.

As soon as you drop the object, the Select Script Component Type dialog box (shown in Figure 19-3) is displayed, which enables you to specify how you intend to use this Script component in the ...

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