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.
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...