Script Task
The Script Task lets you write your own code to extend the package functionality and get the job done. The ability to use your own code is provided by the Script task in Control Flow and by the Script component in Data Flow. To provide an IDE, the Script task and the Script component uses Visual Studio for Applications (VSA).
Using VSA, you can write scripts with Visual Basic 2005. This is the only supported language in the current release of SSIS, which means you cannot use other .NET languages such as C# or J#. Not to worry, though, as Visual Basic 2005 is a fully featured object-oriented language and is easy to program. If your business rules are already coded in .NET languages such as C# or J#, you can compile it into a .NET ...
Get Hands-On Microsoft SQL Server™ 2005 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.
