Bagikan melalui


Generating Dump Files for Package Execution

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

Note

Debug dump files might contain sensitive information. To help protect sensitive information, you can use an access control list (ACL) to restrict access to the files, or copy the files to a folder that has restricted access. For example, before you send your debug files to Microsoft support services, we recommend that you remove any sensitive or confidential information.

When you deploy a project to the Integration Services server, you can create dump files that provide information about the execution of the packages contained in the project. When the ISServerExec.exe process ends, the dump files are created. You can specify that a dump file is created when errors occur during the package execution, by selecting the Dump on errors option in the Execute Package Dialog box. You can also use the following stored procedures:

If you are deploying packages using the package deployment model, you create the debug dump files by using either the dtexec utility or the dtutil utility to specify a debug dump option in the command line. For more information, see dtexec Utility and dtutil Utility. For more information about the package deployment model, see Deployment of Projects and Packages and Package Deployment (SSIS).

Debug Dump File Format

When you specify a debug dump option, Integration Services creates the following debug dump files:

  • A .mdmp debug dump file. This is a binary file.

  • The .tmp debug dump file. This is a text formatted file.

By default, Integration Services stores these files in the folder, <drive>:\Program Files\Microsoft SQL Server\110\Shared\ErrorDumps.

The following table describes only certain sections in the .tmp file. The .tmp file includes additional data that is not listed in the table.

Type of information

Description

Example

Environment

Operating system version, memory usage data, process ID, and process image name. The environment information is at the beginning of the .tmp file.

# SSIS Textual Dump taken at 9/13/2007 1:50:34 PM

#PID 4120

#Image Name [C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTExec.exe]

# OS major=6 minor=0 build=6000

# Running on 2 amd64 processors under WOW64

# Memory: 58% in use. Physical: 845M/2044M  Paging: 2404M/4095M (avail/total)

Dynamic-link library (DLL) path and version

Path and version number of each DLL that the system loads during the processing of a package.

# Loaded Module: c:\bb\Sql\DTS\src\bin\debug\i386\DTExec.exe (10.0.1069.5)

# Loaded Module: C:\Windows\SysWOW64\ntdll.dll (6.0.6000.16386)

# Loaded Module: C:\Windows\syswow64\kernel32.dll (6.0.6000.16386)

Recent messages

Recent messages issued by the system. Includes the time, type, description, and thread ID of each message.

[M:1]   Ring buffer entry:              (*pRecord)

[D:2]      <<<CRingBufferLogging::RingBufferLoggingRecord>>> ( @ 0282F1A8 )

[E:3]         Time Stamp: 2007-09-13 13:50:32.786      (szTimeStamp)

[E:3]         Thread ID: 2368           (ThreadID)

[E:3]         Event Name: OnError                        (EventName)

[E:3]         Source Name:                (SourceName)

[E:3]         Source ID:                        (SourceID)

[E:3]         Execution ID:                 (ExecutionGUID)

[E:3]         Data Code: -1073446879              (DataCode)

[E:3]         Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "".

Execute Package Dialog Box

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.