Home Forums SQL Server 2008 SQL Server 2008 - General can we install 2008 R2 integration services and 2012 integration services on the same server RE: can we install 2008 R2 integration services and 2012 integration services on the same server

  • 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