O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

Building a Package

Building a package consists of several steps:

  • Creating connection managers

  • Building the control flow

  • Establishing precedence constraints

  • Building the data flow

  • Adding in exception handling

  • Creating a configuration file

  • Deploying the package

Note

Note

As with any development activity, it should be understood that you save your work often and you test each change that is made.

Connections

Connection Managers define the connection strings to any objects that your package will interact with, such as files and databases. Connections are added in the Connection Managers pane at the bottom of the main design surface.

In the following exercise, you will ...

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