Using the Data Streaming Destination

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?


May 22nd, 2015 8:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics