SSISDB4: Using Debug Dump Files

In integration Services, you can create debug dump files, this provide information about the execution of a package. The information in these files can help you in troubleshooting package execution issues.

By default, integration Services stores these files in the folder, <drive>:\program Files\Microsoft SQL Server\1 00\shared\errordumps.

The SP that created debug dump file is as follows and can only create debug dump files for the running package.

[] execution_id

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.

[@execution_id =] execution_id

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

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.

Reference Documentation:

Working with Debug Dump Files

Catalog.create_execution_dump

SSISDB4: Using Debug Dump Files