Brandie Tarvin wrote:
Ummmm. Since when doesn't SQL 2012 have access to Integration Services as a separate connection? We use SQL 2012 and connect to Integration Services separately all the time. And no, we don't use the Catalogs. We upload our packages to SQL Server. We've never had an issue. Of course, I haven't worked extensively in SQL 2017 yet. So I don't know how SSIS works in it.
I haven't got to use 2014+ yet, but I'm not aware they've removed the Integration Services Service as yet; I don't even think it's deprecated either.
You do, however, have to use the correct version of SSMS to connect to the SSIS service. So, you have to use SSMS 2012 to connect to SSIS 2012, SSMS 2014 for SSIS 2014, etc, etc. Not sure why SSMS doesn't support the other versions, as I'm pretty sure that you can connect to any version of SSRS that is on a supported version of SQL Server (for that version of SSMS). I have no idea about SSAS though, but I don't recall reading anything about it not being back compatible.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.