Updated: 14 April 2006
Microsoft SQL Server 2005 Integration Services (SSIS) includes a configuration file for configuring the Integration Services service.
By default, the file is located in the folder, Program Files\Microsoft SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml.
The default configuration file contains the following settings:
- Packages are sent a stop command when the service stops.
- The root folders to display for Integration Services in Object Explorer of SQL Server Management Studio are the MSDB and File System folders.
- The packages in the file system that the Integration Services service manages are located in %Program Files%\Microsoft SQL Server\90\DTS\Packages.
You can modify the configuration file to allow packages to continue running if the service stops, to display additional root folders in Object Explorer, or to specify a different folder or additional folders in the file system to be managed by Integration Services service.
The registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile specifies the location and name for the configuration file that Integration Services service uses. The default value of the registry key is C:\Program Files\Microsoft SQL Server\90\DTS\Binn\ MsDtsSrvr.ini.xml. You can update the value of the registry key to use a different name and location for the configuration file.
.gif) Caution: |
|---|
| Incorrectly editing the registry can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. For information about how to back up, restore, and edit the registry, see Microsoft Knowledge Base article 891957. |
The Integration Services service loads the file when the service is started. Any changes to the registry entry require that the service be restarted.
The configuration file can be updated by using a text editor. After you modify the service configuration file, you must restart the service to use the updated service configuration.
.gif) Note: |
|---|
| Some characters are not valid in folder names. Valid characters for folder names are determined by the .NET framework class System.IO.Path and the InvalidPathChars field. The InvalidPathChars field provides a platform-specific array of characters that cannot be specified in path string arguments passed to members of the Path class. Invalid characters might include the quotation mark ("), less than (>) character, and pipe (|) character. |
If you are connecting to a named instance of SQL Server you must update the configuration file to specify the named instance.
The following XML code shows an example of a default configuration file for Integration Services. It specifies that packages stop running when the Integration Services service stops, that the root folders in Integration Services are MSDB and File System, and that the packages in the Packages folder are monitored by the service.
This file is for the default instance of instance of SQL Server.
<?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>.</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>
Configuration File for a Named Instance of SQL Server
The following XML code shows an example of a modified configuration file for Integration Services. This file is for a named instance of SQL Server called InstanceName on a server named ServerName.
<?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>ServerName\InstanceName</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration> <?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">