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

Executing and managing packages programmatically

One of the most useful aspects of SSIS programming is executing and managing packages. We can load a package from DTSX file or SQL Server, add or configure logging parameters and other configuration, and execute it. This is a very useful ability because you may want to create a .NET application for managing packages, so you will need to run and manage packages programmatically.

In this recipe, we will save the package from the Working with Data Flow components programmatically recipe and then add logging to it and execute it.

Getting ready

As this recipe is a complement to the previous recipe, just do steps 1 to 17 from previous recipe.

How to do it...

  1. Write the following statements after step 17 of ...

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