The Data Streaming Destination comes with the Microsoft SQL Server 2012 Integration Services Data Feed Publishing Components, which can be downloaded using this link. To demonstrate the functionality, I created a simple SSIS package that reads data from the DimCustomer table of the AdventureWorks database. The output is then routed to the Data Streaming Destination. The project containing the package is then deployed to the Integration Services Catalog on a SQL Server 2012 (project deployment model). Here is the path and package name that I used for this example:

Next we need to create a linked server to SSIS. In order to do so, two prerequisites have to be checked:

SSISOleDb Provider has to be installed

The “Allow inprocess” option of the SSISOleDb provider has to be enabled

You can check this in Management Studio using the object explorer by expanding the tree Server Objects/Linked Servers/Provider: Double click the SSISOLEDB entry brings up the configuration dialog: Make sure the option “Allow inprocess” is enabled. You may use this dialog or execute the following script: