SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Running SSIS 2008 and SSIS 2012 on same server


Running SSIS 2008 and SSIS 2012 on same server

Author
Message
tbraithwaite
tbraithwaite
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 46
Hi guys, hope someone can help me out.

This msdn article: http://msdn.microsoft.com/en-us/library/ms143731.aspx suggests that SSIS 2012 can be installed on the same server as SSIS 2008, although confusingly in the Instance Configuration section it says only one instance of SSIS can be installed on a computer.

Can you tell me if I can run both on the same server and if so how do I get SSMS to recognise the 2012 instance? The SSIS installation has gone fine, onto a Server 2008 R2 box, and I can see that the services are running, but SSMS only picks up the SSIS 2008 instance.

Any advice appreciated.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58823 Visits: 13297
I think what the article means is that you cannot install for example SSIS 2012 twice on the same machine, but you can install SSIS 2008 and 2012 on the same machine. You'd have to modify one of the configuration files of the service though, to point to the correct MSDB database.

The problem is that SSIS is instance unaware, so SSMS will look for only one instance. Not sure on how to solve this.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
tbraithwaite
tbraithwaite
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 46
Thanks Koen,

I think I may have found a solution. Both instances run OK, but you need to use SSMS 2008 to manage the SSIS 2008 instance and SSMS 2012 to manage the SSIS 2012 instance.

Tony
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58823 Visits: 13297
tbraithwaite (7/29/2013)
Thanks Koen,

I think I may have found a solution. Both instances run OK, but you need to use SSMS 2008 to manage the SSIS 2008 instance and SSMS 2012 to manage the SSIS 2012 instance.

Tony


I was thinking about that option and thought: "Nah, that would be too easy for Microsoft" :-D


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
raygaitherjr
raygaitherjr
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 84
This thread is old but I have the same question now. We want to know if we can install SSIS 2012 and 2014 on the same server. Was this successful or no?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58823 Visits: 13297
raygaitherjr (3/9/2016)
This thread is old but I have the same question now. We want to know if we can install SSIS 2012 and 2014 on the same server. Was this successful or no?


Never tried it.
SSIS is instance unaware, so it might still be an issue.
But, if you use the project deployment model, SSIS is contained in the SSIS catalog.

Only one way to know for sure: test it out :-)


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search