O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

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

CHAPTER 2

image

Script Task vs. Script Component

Within SSIS, .NET scripts can be written in a Script Task or in a Script Component. The purpose of the Script Task and Script Component is to extend the functionality of SSIS with your own custom code when the out-of-the-box tasks and components don’t meet your requirements. And there are more similarities between Script Task and Script Component. They both have a general editor such as in Figure 2-1 to specify properties such as scripting language and the usages of variables. And they both have a VSTA editor to write Visual C# or Visual Basic code.

Figure 2-1. General Script Task Editor

 Note  Since ...

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