Install SSIS on an existing Cluster - SQL 2008 R2

• alnor

  Right there with Babe

  Points: 762

  More actions

  July 16, 2017 at 4:42 pm

  #322641

  Hi Guys

  Have been asked to install SSIS on a cluster
  This is SQL 2008 R2
  Have found the instructions to install SSIS on eack node

  is there anything else I need to do ?

  Thanks

• alnor

  Right there with Babe

  Points: 762

  More actions

  July 17, 2017 at 8:42 pm

  #1951304

  The instructions have the following line at end

  Note: Don’t forget to alter you <ServerName>.\SQL2008</ServerName> property in the MsDtsSrvr.xml file to correctly point to your SQL virtual server name rather than the default “.\InstanceName” that is currently there.

  Where is this file located ?
  I am looking at a  server where ssis is already installed but the file is not even configured

  located in 100\DTS\Binn

  Thanks

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  July 21, 2017 at 8:27 am

  #1952107

  where did you install the feature to?
  search the local drives for the ini file

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"