CHAPTER 2
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
