Events Logged by the Integration Services Service


Applies To: SQL Server 2016

The Integration Services service logs various messages to the Windows Application event log. The service logs these messages when the service starts, when the service stops, and when certain problems occur.

This topic provides information about the common event messages that the service logs to the Application event log. The Integration Services service logs all the messages described in this topic with an Event Source of SQLISService.

For general information about the Integration Services service, see Integration Services Service (SSIS Service).

When you select Integration Services for installation, the Integration Services service is installed and started, and its Startup Type is set to Automatic.

Event IDSymbolic NameTextNotes
256DTS_MSG_SERVER_STARTINGStarting Microsoft SSIS Service.The service is about to start.
257DTS_MSG_SERVER_STARTEDMicrosoft SSIS Service started.The service started.
260DTS_MSG_SERVER_START_FAILEDMicrosoft SSIS Service failed to start.%nError: %1The service was not able to start. This inability to start might be the result of a damaged installation or an inappropriate service account.
258DTS_MSG_SERVER_STOPPINGStopping Microsoft SSIS Service.%n%nStop all running packages on exit: %1The service is stopping, and if you configure the service to do this, will stop all running packages. You can set a true or false value in the configuration file that determines whether the service stops running packages when the service itself stops. The message for this event includes the value of this setting.
259DTS_MSG_SERVER_STOPPEDMicrosoft SSIS Service stopped.%nServer version %1The service stopped.

Settings for the Integration Services service are stored in an XML file that you can modify. For more information, see Configuring the Integration Services Service (SSIS Service).

Event IDSymbolic NameTextNotes
274DTS_MSG_SERVER_MISSING_CONFIG_REGMicrosoft SSIS Service: %nRegistry setting specifying configuration file does not exist. %nAttempting to load default config file.The Registry entry that contains the path of the configuration file does not exist or is empty.
272DTS_MSG_SERVER_MISSING_CONFIGMicrosoft SSIS Service configuration file does not exist.%nLoading with default settings.The configuration file itself does not exist at the specified location.
273DTS_MSG_SERVER_BAD_CONFIGMicrosoft SSIS Service configuration file is incorrect.%nError reading config file: %1%n%nLoading server with default settings.The configuration file could not be read or is not valid. This error might be the result of an XML syntax error in the file.
Event IDSymbolic NameTextNotes
336DTS_MSG_SERVER_STOPPING_PACKAGEMicrosoft SSIS Service: stopping running package.%nPackage instance ID: %1%nPackage ID: %2%nPackage name: %3%nPackage description: %4%nPackageThe service is trying to stop a running package. You can monitor and stop running packages in Management Studio. For information about how to manage packages in Management Studio, see Package Management (SSIS Service).

For information about how to view log entries, see View Log Entries in the Log Events Window

Events Logged by an Integration Services Package

Community Additions