Hi All,

Would like to ask on how can I configure SSIS to point on a Named Instance by default

 I tried editing config and alter with ServerName\InstanceName

after I started services for the instance name and still didn't work...

You will find the file in: “SQL Sever install dir”\90\DTS\Binn (e.g. c:\Program Files\Microsoft SQL Server\90\DTS\Binn)

<?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>

Is there other way to config SSIS ??

Thanks and Regards,

JHOY 

Yes it is as I see http://msdn.microsoft.com/en-us/library/ms137789.aspx too