SQL Server 2008 R2

Product Name

SQL Server 

Product Version


Product Build Number

Event ID


Event Source



Integration Services 

Symbolic Name


Message Text

Microsoft SSIS Service configuration file does not exist.%nLoading with default settings.

The configuration file does not exist at the specified location.

The Integration Services service relies on a configuration file for its settings. By default, the name for this configuration file is MsDtsSrvr.ini.xml, and the file is located in the folder, %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn. The registry key that specifies the location of the configuration file is HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS\ServiceConfigFile.

Possible Causes

This message might appear because of one of the following problems:

  • The file has been deleted or moved.

  • The registry entry that contains the location of the file is incorrect.

  • The file is present but cannot be accessed.

Depending on why the configuration file cannot be found, you might have to take one of the following steps:

  • Locate the moved file and restore this file to the default location. Or, if the file cannot be found, use Setup to repair the Integration Services installation.

  • Ensure that the registry entry that contains the location of the file is correct.

  • Ensure that the account under which the Integration Services service is running has the following settings:

    • Permission to access and read the configuration file.

    • Permission to access and read the registry key that contains the location of the file.

Community Additions