Export (0) Print
Expand All

Running Packages

Packages can be run in Business Intelligence Development Studio, from the SQL Server Import and Export Wizard, by using the SQL Server Integration Services package execution utilities, dtExec and DTExecUI, or as a step in a SQL Server Agent job.

Packages are most frequently run in Business Intelligence Development Studio during the development, debugging, and testing of packages. If you run a package from SSIS Designer, the package always runs immediately. When a solution has multiple projects, make sure you set the project that contains the package that you want to run as the startup project before you run the package.

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 Debugging Control Flow.

Integration Services packages can be enabled for logging and you can capture run-time information in log files. For more information, see Integration Services Log Providers and Implementing Logging in Packages.

To run a package

Scheduling SSIS Package Execution in SQL Server Agent

Describes how to use SQL Server Agent to schedule the running of packages.

Running Data Transformation Services (DTS) Packages

Describes how to run packages that were created by using SQL Server 2000 Data Transformation Services (DTS).

Where is my SQL Server Integration Services package running?

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft