How to: Run a Package in Business Intelligence Development Studio

When a package is run in Business Intelligence Development Studio, the package is built and then deployed to a folder. Before you run the package, you can specify the folder in which the package is built. (If you do not specify a folder, the default bin folder is used.) You can also specify which project is built first. After the package stops, the deployed package is deleted. This type of deployment is called design-time deployment.

Note

To configure a package file as a read-only file, in Windows Explorer, right-click the package file, click Properties, and then select Read-only. When a user opens a read-only package in Business Intelligence Development Studio, right-clicks the package in Solution Explorer, and then clicks Execute Package, the user is prompted to save the package.

To run a package

  1. In Solution Explorer, right-click the Integration Services project folder that contains the package you want to run, and then click Properties.

  2. In the <project name> Property Pages dialog box, click Build.

  3. Update the value in the OutputPath property to specify the folder you want to use for design-time deployment, and click OK.

  4. In Solution Explorer, right-click a package, and then click Set as Startup Object to set the startup project.

  5. To run a package, use one of the following procedures:

    • In Solution Explorer, right-click the package, and then click Execute Package.

    • Open the package that you want to run and then click Start Debugging on the menu bar, or press F5. After the package finishes running, press Shift+F5 to return to design mode.