2

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?

Improve this question
1
  • Are you running into errors when trying to deploy to a 2012 server?
    – Antoine Hernandez
    Apr 7, 2016 at 22:13

1 Answer 1

Reset to default
3

I would stop using VS2013 for SSIS 2012. It builds SSIS 2014 packages that can't be deployed to SSIS 2012. Instead install SSDT-BI for VS2012.

Another option is installing SSDT preview for VS2015. It is a currently a release candidate for SQL 2016 but is able to support downlevel versions back to SSIS 2012. So the story will be much less confusing soon (or now if you are willing to use beta software).

Improve this answer
2
  • Thank you for the clarification! Does the SSDT for VS2015 allow you to select a target version for for RS/AS/IS?
    – John
    Apr 10, 2016 at 9:11
  • @John yes, exactly
    – GregGalloway
    Apr 10, 2016 at 11:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.