The Script task and Script component allow you to execute custom Visual Basic or Visual C# code inside your SSIS package control flow or data flow. This way, you can perform complex operations beyond the capabilities of other built-in tasks and transformations. The Script task works like any other task in the control flow. You can use the Script component in the data flow as the source, transformation, or destination.
Both the Script task and the Script component have two design-time modes: you begin editing by specifying properties using the common editors for tasks and components that you are already familiar with, and then switch to a development environment to write the .NET code. The second environment is the Microsoft Visual Studio Tools for Applications (VSTA) environment.
The Script task provides the entire infrastructure for the custom code for you, letting...