Monday, December 6, 2010

Configuring the Integration Services Service

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.

Typically, you do not have to make any changes to this configuration file, nor do you have to change the file's default location. However, you will have to modify the configuration file if your packages are stored in a named instance or a remote instance of Database Engine, or in multiple instances of the Database Engine. Also, if you move the configuration file to a location other than the default location, you will have to modify the registry key that specifies the file location.

Reference:
http://msdn.microsoft.com/en-us/library/ms137789.aspx

No comments:

Post a Comment