I have to connect to SQL Server 2008 and 2012. I have to design SSIS for 2008 only and have 2008 studio currently installed on my workstation. Can I install SSMS 2012 and still develop SSIS packages for 2008? Any hints greatly appreciated.
Hi there, you can run SSMS (management studio) and connect to any SQL Server version. SSMS 2012 & 2014 as far as I am aware no longer need licences as long as you're connecting to a licensed server. So you would be best up upgrade SSMS for the improved environment. However I think there is some confusion. You do not use SSMS for development of SSIS packages. In my environment we have 2008R2 and 2012. For SSIS I use BIDS 2008 and SSDT respectively. I do not believe that SSDT packages will deploy on a 2008/R2 environment. Hope that helps.