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 ...

Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.