Microsoft KB Archive/941151

= How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2 =

Article ID: 941151

Article Last Modified on 9/7/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition, when used with:
 * Microsoft SQL Server 2005 Service Pack 2
 * Microsoft SQL Server 2005 Developer Edition, when used with:
 * Microsoft SQL Server 2005 Service Pack 2
 * Microsoft SQL Server 2005 Enterprise Edition, when used with:
 * Microsoft SQL Server 2005 Service Pack 2
 * Microsoft SQL Server 2005 Workgroup Edition, when used with:
 * Microsoft SQL Server 2005 Service Pack 2

-



Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows XP and Windows Vista



INTRODUCTION
This article describes how to configure the settings of the registry entries for the Sqldumper.exe utility. These registry entries are related to Microsoft SQL Server 2005 Integration Services (SSIS). By configuring these settings, you can obtain a dump file if a fatal exception occurs. These settings let you obtain a full dump file or a partial dump file of these SSIS related processes.

The settings apply only to SQL Server 2005 Integration Services with Service Pack 2 (SP2) or later versions. These settings do not apply to earlier versions of SQL Server 2005 Integration Services.

The settings control the information that the Sqldumper.exe utility includes in the memory dump files of SSIS related processes. By default, when the settings of these registry entries are not present, the Sqldumper.exe utility is configured to generate a minidump file when a fatal exception occurs in an SSIS related process. The minidump file contains limited information about the SSIS related process that has failed.

If an SSIS related process on your computer fails, and you contact Microsoft Customer Support Services (CSS), we may ask you to enable these settings. Therefore, we can obtain a full dump file of the SSIS related process if the SSIS related process fails again. The full dump of the SSIS related process can help us to better diagnose the problem.

Not all SSIS related processes are affected by these settings. These settings affect the following SSIS related processes:
 * DTExec.exe
 * DtsDebugHost.exe
 * Dtshost.exe
 * Dtutil.exe
 * MsDtsSrvr.exe

These settings do not affect the following SSIS related processes:
 * Dtsinstall.exe
 * DTSMigrationWizard.exe
 * DTSWizard.exe



MORE INFORMATION
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

You can enable the SSIS related process to internally call the Sqldumper.exe utility to generate a dump file. To do this, follow these steps.

Note The Sqldumper.exe utility generates the dump file in the &quot;%ProgramFiles%\Microsoft SQL Server\90\Shared\ErrorDumps&quot; folder.  Click Start, click Run, type regedit, and then click OK. Locate and then right-click the following registry subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS

 Point to New, and then click DWORD Value. Type SqlDumperFlags, and then press ENTER . Right-click the MSDTS entry, point to New, and then click DWORD Value. Type SqlDumperMinidumpFlags, and then press ENTER .</ol>

To enable the SSIS related process to generate a full dump file, set the value of the SqlDumperFlags registry entry to 0x01100.

To enable the SSIS related process to generate a minidump file, set the value of the SqlDumperMinidumpFlags registry entry to 0x0120.

The following table lists the full dump flags that the Sqldumper.exe utility uses. You can also use a combination of the various flags that are listed in the table to include specific information in the full dump file. You specify the value of a full dump flag by using the SqlDumperFlags registry entry.

The following table lists the minidump flags that the Sqldumper.exe utility uses. You can also use a combination of the various flags that are listed in the table to include specific information in the minidump file. You specify the value of a minidump flag by using the SqlDumperMinidumpFlags registry entry.

<div class="references_section">