Configure Data Streaming Destination

You can configure the Data Streaming Destination by using the Advanced Editor for Data Streaming Destination dialog box. You can launch this dialog box by double clicking the component (or) by right-clicking the component in the data flow designer and by clicking Edit.

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

Component Properties tab

This tab has the following editable fields:

Field

Description

Name

Name of the data streaming destination component in the package.

ValidateExternalMetadata

Indicates 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.

IDColumnName

The 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.

Input Columns tab

In the top pane of this tab, you see all the available input columns. You select the columns that you want to be included 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.

Input Output Properties tab

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 expand Input Columns. Click the input column name and change the name of the output column name in the right pane.

See Also

Concepts

Data Streaming Destination

Walkthrough: Publish an SSIS Package as a SQL View