SQL Server Performance

Using SSIS on a Named Instance - Updating MsDtsSrvr.ini.xml

Discussion in 'SQL Server 2005 Integration Services' started by DBADave, Dec 20, 2007.

  1. DBADave New Member

    I've read how I need to update MsDtsSrvr.ini.xml to replace "." with the name of my named instance. For example, in the script below I replaced "." with "MYSERVERNAMEMYINSTANCENAME". When I connect to Integration Services do I specify the named instance in the connection string or the default instance? I'm unable to connect specifying the named instance.
    <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
    <TopLevelFolders>
    <Folder xsi:type="SqlServerFolder">
    <Name>MSDB</Name>
    <ServerName>MYSERVERNAMEMYINSTANCENAME</ServerName>
    </Folder>
    <Folder xsi:type="FileSystemFolder">
    <Name>File System</Name>
    <StorePath>..Packages</StorePath>
    </Folder>
    </TopLevelFolders>
    </DtsServiceConfiguration>
    Thanks, Dave
    DBADave, Dec 20, 2007
    #2

  2. satya Moderator

    Have you restarted the SQLAgent & SSIS service after this change?
    Not a solution but I guess it worked me earlier when I have had such issues.
    satya, Dec 21, 2007
    #3

  3. dineshasanka Moderator

    dineshasanka, Jan 6, 2008
    #4

  4. satya Moderator

    Eventually I found out you need to have a restart of SQLAgent when you make any changes to XML file for DTS/SSIS.
    satya, Jan 7, 2008
    #5

  5. deemehtani New Member

    After you have the changes to the .ini.xml file, you need to restart the IIS service on the server in order for this to take effect. It works!
    deemehtani, Jan 8, 2008
    #6

  6. satya Moderator

    IIS?
    Don't think you need IIS for SSIS and it is only for SSRS.
    satya, Jan 9, 2008
    #7

  7. deemehtani New Member

    You are right my bad, I meant IS (SSIS) service
    deemehtani, Jan 10, 2008
    #8

Share This Page