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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » can we install 2008 R2 integration services...

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

Rate Topic

Display Mode

Topic Options

Author

Message

SQListic

Posted Thursday, March 14, 2013 4:59 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:42 PM
Points: 193, Visits: 773

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

arunyadav007

Posted Friday, March 15, 2013 1:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:06 AM
Points: 42, Visits: 285

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

opc.three

Posted Sunday, March 17, 2013 5:01 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 6,703, Visits: 11,733

Sqlism (3/14/2013)

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

SQListic

Posted Monday, March 18, 2013 12:16 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:42 PM
Points: 193, Visits: 773

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

opc.three

Posted Monday, March 18, 2013 2:47 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 6,703, Visits: 11,733

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

SQListic

Posted Tuesday, March 19, 2013 10:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:42 PM
Points: 193, Visits: 773

Help Please

Post #1432763

opc.three

Posted Tuesday, March 19, 2013 11:14 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 6,703, Visits: 11,733

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 »

Permissions