Introduction

SSIS is a Rapid Application Development tool. This means that SSIS developers won't need to write any code to do operations. On the other hand, we saw in Chapter 8, Scripting, that there are two script components that help developers to write their own customized .NET code to do any specific operation which is not listed in SSIS built-in components. All of these features are not enough for calling an ETL tool as an enterprise, because enterprise environment needs extreme dynamism and open-handed environment for developers. And fortunately, SSIS can be done from development to execution with .NET programming. You can create a package with some lines of .NET code, develop control flow and data flow all in code, and finally deploy and execute it with programming. Let's call this great feature SSIS programming.

SSIS programming means doing everything with code. You don't need to do anything with SSDT, but you need Visual Studio. .NET framework and obviously SSIS engine have to be...