SQL Server Performance

SSIS on Named Instance

Discussion in 'SQL Server 2005 Integration Services' started by jhoy, Aug 13, 2008.

  1. jhoy New Member

    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 ServerNameInstanceName
    after I started services for the instance name and still didn't work...
    You will find the file in: “SQL Sever install dir”90DTSBinn (e.g. c:program FilesMicrosoft SQL Server90DTSBinn)
    <?xml version=”1.0″ encoding=”utf-8″?>
    <DtsServiceConfigurationxmlns: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>ServerNameInstanceName</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
  2. satya Moderator

Share This Page