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.

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. Set a startup project by right-clicking a package in Solution Explorer and clicking Set as Startup Object.

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

    • In Solution Explorer, right-click the package, and then click Execute Package.
      —or—
    • Open the package that you want to run and then click Start Debugging on the menu bar, or press F5. After the package completes, press Shift+F5 to return to design mode.

See Also

Tasks

Running Packages

Concepts

Integration Services Packages
Package How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance