Install SQL Server Integration Services SSIS in a different Server

  1. Install SQL Server Integration Services in a Server different to SQL Server Database Server for example in an application server.
  2. In Application Server where you install SSIS modify the follow file to connect a Database Server “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml”
  3. Change  the parameter according to you environment:
    <ServerName>.</ServerName>
    For example:
    <ServerName>SERVERSQL01\INSTANCE03</ServerName>
  4. Restart SQL Server Integration Services.

Comentarios

Publicar un comentario