SSDT 17.2 for VS 2015 - SSIS 2016 packages can't open Analysis Services Processing tasks
I upgraded an SSIS project from 2014 to 2016 using SSDT 14.0.61707.300 in Visual Studio 2015. Upon doing so, whenever I open a Analysis Services Processing Task, I get the following error:
TITLE: Analysis Services Processing Task
Method not found: 'Microsoft.AnalysisServices.ErrorConfiguration Microsoft.AnalysisServices.Commands.BatchCommand.get_ErrorConfiguration()'.
If I revert back down to 2014, I can open it just fine. If I create a new AS Processing Task in the same package or new package in the same solution, I get the same error. If I upgrade the SSIS project to SQL2017, it magically works. The issue is only when the target version is 2016. This is clearly an issue with SSDT
Despite not being able to open the task, the package still executes successfully when I run it.
There are a couple posts about this:
Upvotes: 13<=-=Dec 4 2017 3:53AM=-=>
I’m having a similar problem, but not only with upgraded packages.
I’m having problems also if I create a completely new package
with Integration Services 2016 in Visual Studio 2015 (SDDT version installed is 17.2).
It works if I use Integration Services 2014 or 2017.
I’ve not yet found solution to that issue.
Please let me know if you identify a solution to your issue
Ivan Ceskovic commented
The same problem here (Target is SQL 2016) just a different Method not found (set_Type). It works if I switch to SQL vNext (or 2017), configure the component, and then revert back to SQL 2016 (execution works).
Michael Garrido commented
We also have this issue on serveral developer machines
We're also having trouble with scripting tasks as well, they compile to a sql2017 version, which cannot be deployed!!!
I have the same problem. It works if I use Integration Services 2012, 2014 or 2017, but not 2016!
SSDT 2015 Version: 14.0.61712.050.
SSDT 2017 Version: 14.0.16156.0 does not work either.