Post reply

can we install 2008 R2 integration services and 2012 integration services on the same server

  • March 14, 2013 at 4:59 pm

    #394397

    Hi DBA'S

    I had 2012 integration services installed on a server. i am trying to connect to Oracle but it is failing. I worked with Same SSIS Pkg in 2008 r2 where i can connect to oracle and import data. So i am planning to install sql server 2008 r2 ssis on the same box where 2012 is installed. My Database engine will be 2012. can i do this ?

    please advise

    Thanks a alot in adavnce

  • March 15, 2013 at 1:03 am

    #1597361

    Hello,

    According to my understanding, you can only install 1 physical instance of SSIS on each machine. Check the following link for an article which discusses the same.

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ec460c06-5a6f-4880-aefb-5d1eaa09c42b/

  • March 17, 2013 at 5:01 pm

    #1597930

    Sqlism (3/14/2013)

    Hi DBA'S

    I had 2012 integration services installed on a server. i am trying to connect to Oracle but it is failing. I worked with Same SSIS Pkg in 2008 r2 where i can connect to oracle and import data. So i am planning to install sql server 2008 r2 ssis on the same box where 2012 is installed. My Database engine will be 2012. can i do this ?

    please advise

    Thanks a alot in adavnce

    You can install both sets of binaries side-by-side, but only one instance of the service. If you need to run SSIS 2008 Packages on a server where SSIS 2012 is installed you can do so by calling the correct version DTExec.exe using a fully-qualified path of the executable.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 18, 2013 at 12:16 pm

    #1598139

    Thanks for the reply!

    Can you please explain this in more details, i use Execution utility for running this packages. so how can i differentiate 2012 and 2008R2 SSIS.

    So you conclude that we can install 2008r2 on the server where 2012 is installed, if so what precautions should be taken while installing SSIS 2008R2...

    Thanks everyone in advance!

  • March 18, 2013 at 2:47 pm

    #1598177

    Sqlism (3/18/2013)

    Thanks for the reply!

    Can you please explain this in more details, i use Execution utility for running this packages. so how can i differentiate 2012 and 2008R2 SSIS.

    The path. Each install has it's own Tools folder. Search for DTExec.exe on your machine.

    So you conclude that we can install 2008r2 on the server where 2012 is installed, if so what precautions should be taken while installing SSIS 2008R2...

    If you already have 2012 installed you may be denied installing the 2008 R2 IS service. That I have not tried so could not advise. Worst case you can get the 32-bit version of the 2008 R2 DTExec.exe by installing BIDS from the 2008 R2 media.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 19, 2013 at 10:20 am

    #1598523

    Help Please

  • March 19, 2013 at 11:14 am

    #1598547

    Sqlism (3/19/2013)

    Help Please

    What are you having trouble with?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 7 posts - 1 through 6 (of 6 total)

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