SSIS service does not support multi-instance, use just server name instead of "server name\instance".

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 28, 2016 at 9:19 pm

  #323315

  Hi Experts,

  Wanted to know why SSIS does not support multi instance , say named instance?

  Thanks.

• rvsc48

  SSCertifiable

  Points: 7685

  More actions

  November 29, 2016 at 9:28 am

  #1914989

  Hi, SQL Server Integration Services is not instance-aware; i.e. you can only install a single instance of the Integration Services service on your server. However, there is a work around in getting SSIS to be recognized with a named instance. See - https://www.mssqltips.com/sqlservertip/2061/how-to-manage-ssis-packages-stored-in-multiple-sql-server-database-instances/