Creating and configuring Control Flow Tasks programmatically
Control Flow Tasks are executable objects in an SSIS package. Creating those objects programmatically and configuring them are the first steps of SSIS programming. In other words, you cannot create a package without any task!
Package is the main object which is needed in order to do SSIS Programming . SSIS Package is under the Microsoft.SqlServer.Dts.Runtime namespace. In this recipe, we will create a package and add a File System Task to it to copy a file to a destination folder.
Getting ready
Microsoft Visual Studio 2010 is needed to do this recipe.
How to do it...
Open SSDT or Visual Studio. Under Visual C#, create a Console Application project and name it as
R01_Creating and Configuring Control Flow Task Programmatically.In the Solution Explorer, right-click on the References folder and click on Add reference.
In the Add Reference window, go to the .NET tab and select Microsoft.SQLServer.ManagedDTS and then click OK.
Right-click on...
