Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services

Chapter 45. Running SSIS Packages

Now that your packages are deployed, you're ready to run them. In this lesson, you see how to execute a package from a variety of places like Management Studio and from the command line. You also see some of the key differences between 32- and 64-bit machines and some of the items that may not work on a 64-bit machine.

Before we begin, one important caveat is that even though your package is deployed onto a server, the package uses the resources and runs from whichever machine executes it. For example, say you deploy a package to your production server and then you connect through Management Studio and execute the package from your work laptop. In this case, the package will use your laptop's resources, not the production server's resources, to run the package and will likely overwhelm your laptop.

One way to run a package is through Management Studio. Simply open Management Studio for SQL Server 2008 and connect to the Integration Services service.

In case you're skipping around, Lessons 42 and 43 discuss how to connect and configure the SSIS service.

Once connected, you can right-click any package that's stored on the msdb database or in the file system and click Run Package to execute the package.

After you click Run Package, the Execute Package Utility opens. You can also access this utility by double-clicking any package in Windows Explorer or by just running DTExecUI. The tool wraps a command-line package executor called DTExec.exe.

The Execute ...