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

Running SSIS 2008 and SSIS 2012 on same server Expand / Collapse
Author
Message
Posted Monday, July 29, 2013 6:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 29, 2014 9:08 AM
Points: 7, Visits: 35
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.
Post #1478558
Posted Monday, July 29, 2013 7:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 13,731, Visits: 10,688
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1478570
Posted Monday, July 29, 2013 7:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 29, 2014 9:08 AM
Points: 7, Visits: 35
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
Post #1478573
Posted Monday, July 29, 2013 12:48 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 13,731, Visits: 10,688
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"




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

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1478713
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse