SSIS Configuration File

The SSIS Config file is called MsDtsSrvr.ini.xml. It is located in C:\Program Files\Microsoft SQL Server\90\DTS\Binn on my install.

I had to hunt it down as after installing Integration Services the service would not start.
It turned out that it didnt like the fact that I have named instances of SQL 2005 (no default instance) and SSIS doesnt detect named instances by default.

Adding the instance name inside the servername tags sorted my problem.

<dtsserviceconfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><br /> <stopexecutingpackagesonshutdown>true</StopExecutingPackagesOnShutdown><br /> <toplevelfolders><br /> <folder xsi:type="SqlServerFolder"><br /> <name>MSDB</Name><br /> <servername>RIO\ALPHA</ServerName><br /> </Folder><br /> <folder xsi:type="FileSystemFolder"><br /> <name>File System</Name><br /> <storepath>..\Packages</StorePath><br /> </Folder><br /> </TopLevelFolders> <br /></DtsServiceConfiguration> </servername>