Sample Header Ad - 728x90

SSDT-BI SQL Version Compatability

2 votes
1 answer
210 views
I'm working on upgrading some SSIS packages from SQL Server 2008 R2 to 2012 and am getting somewhat confused by the SSDT-BI tools. I have downloaded "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013" from here , which according to this supports "SQL Server 2014, SQL Server 2012, SQL Server 2008 and 2008 R2". When upgrading a package I don't see an option to upgrade "up to 2012" only. In other words, how can I stop the packages being upgraded too far? Or are 2012/14 pretty much cross compatible? Also, are there other similar implications for SSRS, SSAS solutions? If I need a different version to ONLY upgrade to 2012, which would I need?
Asked by John (23 rep)
Apr 7, 2016, 08:05 PM
Last activity: Apr 8, 2016, 07:42 AM