Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

catalog.create_execution_dump

SQL Server 2012

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


          
create_execution_dump [ @execution_id = ] execution_id

        
[ @execution_id = ] execution_id

The execution ID for the running package. The execution_id is bigint.

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


0 (success)

When the stored procedure fails, it throws an error.

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.