Configure the integration server

  1. Locate the MsDtsSrvr.ini.xml file.

    Depending on your operating system and version of SQL, this is default location for this file:

    • Microsoft SQL Server 2019

      C:\Program Files\Microsoft SQL Server\150\DTS\Binn

      – or –

      C:\Program Files(x86)\Microsoft SQL Server\150\DTS\Binn

    • Microsoft SQL Server 2017

      C:\Program Files\Microsoft SQL Server\140\DTS\Binn

      – or –

      C:\Program Files(x86)\Microsoft SQL Server\140\DTS\Binn

    • Microsoft SQL Server 2016

      C:\Program Files\Microsoft SQL Server\130\DTS\Binn

      – or –

      C:\Program Files(x86)\Microsoft SQL Server\130\DTS\Binn

    • Microsoft SQL Server 2014

      C:\Program Files\Microsoft SQL Server\120\DTS\Binn

      – or –

      C:\Program Files(x86)\Microsoft SQL Server\120\DTS\Binn

  2. In a text editor, access MsDtsSrvr.ini.xml.
  3. Edit the Server setting to the Microsoft SQL Server that is being used. For example:

    <ServerName><MySQLServer>\<MySQLServerInstance></ServerName>

    Where MySQLServer is the Microsoft SQL Server name and MySQLServerInstance is the instance name.

  4. Save and close the file.
  5. Restart the Integration Services.