O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

  1. Open SSDT or Visual Studio. Under Visual C#, create a Console Application project and name it as R01_Creating and Configuring ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required