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?