Post reply

Install SSIS on an existing Cluster - SQL 2008 R2

  • 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

  • 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

  • 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" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply