Microsoft SQL Server 2005 Integration Services

These are some pretty easy examples and show how the Script Component can fill the functional gaps of Integration Services with just a few lines of code. You've seen how to write a source and destination adapter. You've seen how to write a transform with synchronous and asynchronous outputs. Using the Script Component, you can write your own data-processing logic or use existing legacy code. You can even use third-party algorithms or the .NET Framework. The possibilities are nearly infinite.