Our organization's security team has advised us to remove visual studio 2010 and components as the software has reached the end of the life cycle. But if I remove visual studio 2010 components, our management studio stops working.
We have SQL 2012/2014 installed. The security team has pointed out the following dll "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\\mspdbcore.dll Version is 10.0.40219.478#"
If I do install a newer version of SSMS, then I am unable to connect to integration services. Currently from the Microsoft site, I see 16.5.3 as the oldest version. This version cannot connect to SQL 2012/2014 integration services.
Is there a management studio available that does not uses visual studio 2010 components and can connect to integration services 2012/2014?