Introduction

In previous chapters, many aspects of SSIS Development Components were revealed. SSIS has a bunch of Tasks and Transformations that help ETL or Data Integration developers to create their package faster, more easily, and with greater reliability. However, there are times when a requirement cannot be met with built-in tasks and transformations. Every ETL Tool should have a way to overcome this common problem.

SSIS provides a way to write your own custom code in a .NET language and execute it during Control Flow or Data Flow. A combination of SSIS and the Microsoft .NET Framework makes scripting in SSIS a great way to handle anything in custom code.

Our scripting language could be C# or VB.NET, and the .NET 4.0 Framework is fully supported in this version of SSIS. This is one of the main advantages of SSIS 2012 over the 2008 version, because in SSIS 2008 only VSTA 2.0 was supported. In SSIS 2005, a developer had no choice but to write code in VB.NET.

There are two locations for writing...