Chapter 57

Running SSIS Packages

When 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 you begin, there is one important caveat for packages in the package deployment model deployed to the SQL Server. 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. For packages in the project deployment model, this will not be the case. They would run on the server, using its resources.

One way to run a package is through Management Studio. Simply open Management Studio and connect to the Integration Services service for packages in the package deployment model or to the database instance for those stored in the project deployment model.

NOTE In case you’re skipping around, Lesson 55 discusses how to connect and configure the SSIS service.

Once connected, you can right-click any package and click Run Package (or Execute catalog packages) ...

Get Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.