Run a Package in SQL Server Data Tools

  • Article

You typically run packages in SQL Server Data Tools (SSDT) during the development, debugging, and testing of packages. When you run a package from SSIS Designer, the package always runs immediately. 

While a package is running, SSIS Designer displays the progress of package execution on the Progress tab. You can view the start and finish time of the package and its tasks and containers, in addition to information about any tasks or containers in the package that failed. After the package finishes running, the run-time information remains available on the Execution Results tab. For more information, see the section, "Progress Reporting," in the topic, Debugging Control Flow.

Design-time deployment. When you run a package in SQL Server Data Tools, the package is built and then deployed to a folder. Before you run the package, you can specify the folder to which the package is deployed. If you do not specify a folder, the bin folder is used by default. This type of deployment is called design-time deployment.

To run a package in SQL Server Data Tools

  1. In Solution Explorer, if your solution contains multiple projects, right-click the Integration Services project that contains the package, and then click **Set as StartUp Object **to set the startup project.

  2. In Solution Explorer, if your project contains multiple packages, right-click a package, and then click Set as StartUp Object to set the startup package.

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

    • 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.

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

To specify a different folder for design-time deployment

  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.

See Also

Tasks

Execution of Projects and Packages

Concepts

Integration Services (SSIS) Packages