Analysis Services task throwing error when TargetServerVersion for project set to SQL2016

• Matthew Cushing

  SSCrazy

  Points: 2898

  More actions

  October 13, 2017 at 2:38 pm

  #339893

  I have a package that utilizes several Analysis Services Processing tasks that are currently housed on an instance of SSIS on SQL 2012.  I want to upgrade the packages for our new 2016 SQL instance using SSDT (visual studio 2015).  I created a new project with the TargetServerVersion set to SQL Server 2016.  When I import the packages and upgrade them, all of the packages are fine except the ones with the AS tasks.  When I try to open one of the AS Tasks, I get an error: 
  
Method not found: 'Microsoft.AnalysisServices.ErrorConfiguration Microsoft.AnalysisServices.Commands.BatchCommand.get_ErrorConfiguration()'.


  I thought there must be something wrong with SSDT, so I created another project setting targetVersion to 2012, and I can open it fine.  when I set it to SQL Server vNext, it's fine.  It's only when I have it set to 2016 that I have an issue and that's the version of the server I'm deploying to.
  I was looking at this post, thinking I might be missing a DLL necessary, but I'm finding the right one for 2016, so I'm stumped (MSOLAP.7 released in SQL Server 2016 (filename is msolap130.dll))

  What DLL is vNext using?  There is a dll called msolap.dll located here -C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\140, figuring that might be it.

  I guess I'm trying to narrow down why it'd be fine with the TargetServerVersion set to 2012 or vNext, but craps out when I have it set to 2016.
  Any advice would be appreciated.

• floresg2

  Old Hand

  Points: 397

  More actions

  October 23, 2017 at 10:35 am

  #1964822

  I'm encountering the same issue after upgrading SSIS 2014 to 2016. I have Data Tools 14.0.61707.300

  The issue seems to be related to the version of Data Tools installed according to this post:
  It suggests using 14.0.61021.0 (SSDT 16.5). It can be downloaded below: 
  https://social.msdn.microsoft.com/Forums/vstudio/en-US/db51d769-929c-4e5e-9c9e-deb7d1059bbd/a-problem-with-sql-server-data-tools-build-14061704140?forum=sqlanalysisservices

  https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi

  I created a Connect item here, please vote for it
  https://connect.microsoft.com/SQLServer/feedback/details/3142933