SSIS packages that are currently running may unexpectedly stop responding when you restart the SSIS service in SQL Server 2005 (904798)


The information in this article applies to:

  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition

SYMPTOMS

In Microsoft SQL Server 2005, when you restart the SQL Server 2005 Integration Services (SSIS) service, the SSIS package that is currently running may unexpectedly stop responding.

CAUSE

This behavior may occur because of an incorrect node setting in the SSIS service configuration file. Every time that the SSIS service starts, the service reads the SSIS configuration file. One of the nodes in the SSIS configuration file determines how the SSIS service will handle packages that may be running if the SSIS service stops responding. If this node is set incorrectly, the service issues a stop request to the SSIS runtime as soon as the SSIS service stops responding. When this behavior occurs, each package that is running is stopped.

RESOLUTION

To resolve this behavior, you must modify the SSIS service configuration file to enable packages to continue to run even if the SSIS service stops responding. The name of the SSIS service configuration file is MsDtsSrvr.ini.xml. By default, the MsDtsSrvr.ini.xml file is located in the Program Files\Microsoft SQL Server\90\DTS\Binn folder.

To modify the SSIS service configuration file, follow these steps.
  1. In Notepad, open the MsDtsSrvr.ini.xml file.
  2. Locate the following node: 
    <StopExecutingPackagesOnShutdown>TRUE</StopExecutingPackagesOnShutdown>
  3. In the node that you located in step 2, change TRUE to FALSE, so that the node appears as follows: 
    <StopExecutingPackagesOnShutdown>FALSE</StopExecutingPackagesOnShutdown>
  4. Save and then close the MsDtsSrvr.ini.xml file.
Note After you have modified the SSIS service configuration file, restart the SSIS service to apply updated service configuration.

REFERENCES

For more information about the SSIS service configuration file, see the following topics in SQL Server 2005 Books Online:
  • Managing Integration Services Service
  • Configuring the Integration Services Service
Modification Type:MajorLast Reviewed:3/11/2006
Keywords:kbhowto kbsql2005ssis kbinfo KB904798 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.