catalog-create-execution-dump.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
catalog.create_execution_dump	catalog.create_execution_dump	chugugrace	chugu	03/04/2017	sql	integration-services	language-reference

catalog.create_execution_dump

[!INCLUDEsqlserver-ssis]

[!INCLUDE SQL Server]

Causes a running package to pause and create a dump file. The file is stored in the <drive>:\Program Files\Microsoft SQL Server\130\Shared\ErrorDumps folder.

Syntax

catalog.create_execution_dump [ @execution_id = ] execution_id  
  

Arguments

[ @execution_id = ] execution_id
The execution ID for the running package. The execution_id is bigint.

Example

In the following example, the running package with an execution ID of 88 is prompted to create a dump file.

EXEC create_execution_dump @execution_id = 88  

Return Codes

0 (success)

When the stored procedure fails, it throws an error.

Result Set

None

Permissions

This stored procedure requires users to be members of the ssis_admin database role.

Errors and Warnings

The following list describes conditions that cause the stored procedure to fail.

• An invalid execution ID is specified.

• The package has already completed.

• The package is currently creating a dump file.

See Also

Generating Dump Files for Package Execution