O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

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

Hands-On Exercise: Creating a Package with Script Tasks

In this chapter, we will just create one project and test the various examples using individual Script Tasks in the 'Canvas'. It is not necessary to disable the task to execute the other task(s), as it is possible to just execute the task you need to execute.

  1. 1. Create a Business Intelligence Project, Ch 19, and rename the default name of the package.

    The default name was changed to scripts.dtsx in this exercise.

  2. 2. Drag and drop a Script Task from the Control Flow Items group from the Toolbox onto the Control Flow page of the Canvas.

  3. 3. Right-click the Script Task and from the drop-down choose Edit… (or double-click the Script Task component).

Simple Calculation

This opens up the Script ...

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