Does anyone know the right combination of server/tools is required to use the Data Streaming Destination?
I am using Visual Studio/SSDTBI 2012 for package creation and deploying to a SQL Server 2014 catalog.
When I validate the package in Visual Studio, no errors or warnings are generated. When I validate the package in the catalog, the following errors occur:
"Data Flow Task:Error: The component metadata for ""Data Streaming Destination, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D}"" could not be upgraded to the newer version of the component. The PerformUpgrade method failed." "Data Flow Task:Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is ""Exposes data in a data flow to other applications via Microsoft OLE DB Provider for SQL Server Integration Services (SSISOLEDB). The exposed data can be consumed by running queries on a linked server that uses the SSISOLEDB provider.;Microsoft Corporation; Microsoft SQL Server; Microsoft Corporation; All Rights Reserved; http://go.microsoft.com/fwlink/?LinkId=313934;0""." "Data Flow Task:Error: Data Streaming Destination failed validation and returned error code 0xC0048021." "Data Flow Task:Error: One or more component failed validation." "Data Flow Task:Error: There were errors during task validation." "Data Flow Task:Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is ""Exposes data in a data flow to other applications via Microsoft OLE DB Provider for SQL Server Integration Services (SSISOLEDB). The exposed data can be consumed by running queries on a linked server that uses the SSISOLEDB provider.;Microsoft Corporation; Microsoft SQL Server; Microsoft Corporation; All Rights Reserved; http://go.microsoft.com/fwlink/?LinkId=313934;0""." "Data Flow Task:Error: The component metadata for ""Data Streaming Destination"" could not be upgraded to the newer version of the component. The PerformUpgrade method failed." "Data Flow Task:Error: The ""Data Streaming Destination"" failed to cache the component metadata object and returned error code 0x80131600." "Data Flow Task:Error: Component Data Streaming Destination, clsid {33D831DE-5DCF-48F0-B431-4D327B9E785D} failed to initialize due to error 0xC0047067 ""The ""%1"" failed to cache the component metadata object and returned error code 0x%2!8.8X!.""." "Data Flow Task:Error: The managed pipeline component ""Microsoft.SqlServer.Dts.DataStreaming.DataStreamingDestinationAdapter, Microsoft.SqlServer.DataStreaming.Dest, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"" could not be loaded. The exception was: Could not load file or assembly 'Microsoft.SqlServer.DataStreaming.Dest, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.."
The 64-bit msi was used to install the Data Stream Publishing components.
Any ideas if this combination of tools is supposed to work?
- Edited by D. Pendleton Friday, May 22, 2015 8:40 PM