Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can we install 2008 R2 integration services and 2012 integration services on the same server Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 4:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 4:57 PM
Points: 225, Visits: 945
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
Post #1431293
Posted Friday, March 15, 2013 1:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 28, 2014 3:22 AM
Points: 42, Visits: 286
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/
Post #1431378
Posted Sunday, March 17, 2013 5:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1432045
Posted Monday, March 18, 2013 12:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 4:57 PM
Points: 225, Visits: 945
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!
Post #1432302
Posted Monday, March 18, 2013 2:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1432348
Posted Tuesday, March 19, 2013 10:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 4:57 PM
Points: 225, Visits: 945
Help Please
Post #1432763
Posted Tuesday, March 19, 2013 11:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1432796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse