Configure Data Streaming Destination


Applies To: SQL Server 2016

Configure the Data Streaming Destination by using the Advanced Editor for Data Streaming Destination dialog box. Open this dialog box by double clicking the component or by right-clicking the component in the data flow designer and then clicking Edit.

This dialog box has three tabs: Component Properties, Input Columns, and Input and Output Properties.

This tab has the following editable fields:

NameName of the data streaming destination component in the package.
ValidateExternalMetadataIndicates whether the component is validated using external data sources at design time. If set to false, validation against external data sources is delayed until runtime.
IDColumnNameThe view generated by the Data Feed Publish Wizard has this additional ID column. The ID column serves as the EntityKey for the output data from the data flow when the data is consumed as an OData feed by other applications.

The default name for this column is _ID. You can specify a different name for the ID column.

In the top pane of this tab, you see all the available input columns. Select the columns that you want to include in the output of this component. The selected columns are displayed in a list in the bottom pane. You can change the name of the output column by entering the new name for the Output Alias field in the list.

Similar to the Input Columns tab, you can change names of output columns in this tab. In the tree view to the left, expand Data Streaming Destination Input and then expand Input Columns. Click the input column name and change the name of the output column name in the right pane.

Data Streaming Destination
Walkthrough: Publish an SSIS Package as a SQL View

Community Additions