O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

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

Hands-On Exercise: Creating a Project with Two Packages

In order to follow the steps as indicated, you will need to create a Business Intelligence project that has two packages. When the first package fails, you will use the OnError event to execute the other package. Simultaneously, when the first package finishes executing you verify that you can successfully ping your default gateway.

The following steps will be described in setting up a BI project with two packages:

  • Create a BI project and rename the default package.

  • Add and configure the package that has a Send Mail task.

  • Add and configure an Execute SQL Task to the renamed default package.

  • Add an Execute Package Task to the OnError event of the renamed default package.

  • Add an Execute Process ...

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