SQLPadawan (5/21/2014)
Forgive me, Jedi Master!I disputed you. I didn't believe you could create more than SSISDB on a single operating system, BECAUSE if you look at the Feature Selection step of installation, as seen here http://www.e-squillace.com/tech/screenshotgallery/SQL/SQL2012/SQL2012_RTM_Install_Steps_files/Step9b-FeatureSelection-SQLFeatures.png, [SUPPOSEDLY] you can only install Integration Services once per operating system.
So, I had to try out the claim that you could install SSIS on more than one instance per operating system. Of course, the Jedi Master was correct. So, Microsoft, a bit of clarification on the installation screen might help.
Also, take a look at this person's hard work:
http://speaksql.wordpress.com/2013/06/
Scroll down to this section, "SSISDB ERD – A Journey to DB deployment automation" to see the reverse engineered SSISDB 2012!
I think you can install Integration Services only once per operating system (for a given edition), but this is just the SSIS service (not really used in the project deployment model) and the necesary binaries to run SSIS. You can however create multiple SSIS catalogs, i.e. one per database instance.
You can also install multiple versions of SSIS, for example SSIS 2012 and SSIS 2014. I should test out someday how well they can live together on one system.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
