SSRS 2012 using SSIS as Data source

• David Bird

  SSCarpal Tunnel

  Points: 4669

  More actions

  April 23, 2015 at 2:41 pm

  #303222

  I have a developer who created a report that uses SSIS as a data source for SSRS report on SQL Server 2008 Standard x64 edition. Now it is time migrate it to SQL 2012 Standard x64 edition.

  Microsoft provided the procedures for enabling SSIS as a SSRS data source for SQL Server 2008. https://technet.microsoft.com/en-us/library/ms345250%28v=sql.100%29.aspx?f=255&MSPPError=-2147217396

  In SQL Server 2012 the SSIS extension line was removed from RSReportServer.config file. I found a suggestion to add the line and change the version from 10. to 11.

  <Extension Name="SSIS" Type="Microsoft.SqlServer.Dts.DtsClient.DtsConnection,Microsoft.SqlServer.Dts.DtsClient, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>

  After restarting SSRS service and restarting the server, it still does not work. On SSRS when selecting SSIS as the data source type: I get this warning:

  The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly.

  Looking at the SSRS Log files it states:

  extensionfactory!ReportServer_0-2!2020!04/23/2015-16:09:24:: e ERROR: Exception caught instantiating SSIS report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Dts.DtsClient, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

  File name: 'Microsoft.SqlServer.Dts.DtsClient, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Dts.DtsClient, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

  File name: 'Microsoft.SqlServer.Dts.DtsClient, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

  WRN: Assembly binding logging is turned OFF.

  To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

  Note: There is some performance penalty associated with assembly bind failure logging.

  To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

  Any suggestions? Did Microsoft pull support for this?

  David Bird