TechNet
Export (0) Print
Expand All

ADO NET Source Editor (Columns Page)

 

Applies To: SQL Server 2016

Use the Columns page of the ADO NET Source Editor dialog box to map an output column to each external (source) column.

To learn more about the ADO NET source, see ADO NET Source.

To open the Columns page

  1. In SQL Server Data Tools (SSDT), open the Integration Services package that has the ADO NET source.

  2. On the Data Flow tab, double-click the ADO NET source.

  3. In the ADO NET Source Editor, click Columns.

Available External Columns
View the list of available external columns in the data source. You cannot use this table to add or delete columns.

External Column
View external (source) columns in the order in which you will see them when configuring components that consume data from this source.

Output Column
Provide a unique name for each output column. The default is the name of the selected external (source) column; however, you can choose any unique, descriptive name. The name provided will be displayed within the SSIS Designer.

ADO NET Source Editor (Connection Manager Page)
ADO NET Source Editor (Error Output Page)
ADO.NET Connection Manager

Community Additions

ADD
Show:
© 2016 Microsoft