Saving SSIS Package to MSDB Database

SSIS does not support multi-instances. It does not allow saving Packages to MSDB database if there are no default SQL Server 2005 installation.

To enable saving packages on the MSDB subfolder in SSIS, You will have to change the MsDtsSrvr.ini.xml file located in C:\Program Files\Microsoft SQL Server\90\DTS\Binn directory. Sample file:



change the line where the red arrow points to the dot(.)to:



Do this ONLY if there are no default instance of SQL SERVER 2005 installed on your Server.