Set the Properties of a Data Flow Component
To set the properties of data flow components, which include sources, destinations, and transformations, use one of the following features:
The component editors that Integration Services provides. These editors include only the custom properties of each data flow component.
The Properties window lists the component-level custom properties of each element, as well as the properties common to all data flow elements.
The Advanced Editor dialog box provides access to custom properties for each component. The Advanced Editor dialog box also provides access to the properties common to all data flow components—the properties of inputs, outputs, error outputs, columns, and external columns.
To set the properties of a data flow component by using a component editor
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
Click the Control Flow tab, and then double-click the Data Flow task that contains the data flow with the component whose properties you want to view and modify.
Double-click the data flow component.
In the component editor, view or modify the property values, and then close the editor.
To save the updated package, on the File menu, click Save Selected Items.
To set the properties of a data flow component by using the Properties window
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
Click the Control Flow tab, and then double-click the Data Flow task that contains the component whose properties you want to view and modify.
Right-click the data flow component, and then click Properties.
View or modify the property values, and then close the Properties window.
Note
Many properties are read-only, and cannot be modified.
To save the updated package, on the File menu, click Save Selected Items.
To set the properties of a data flow component by using the Advanced Editor
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
Click the Control Flow tab, and then double-click the Data Flow task that contains the component you want to view or modify.
In the data flow designer, right-click the data flow component, and then click Show Advanced Editor.
Note
In SQL Server, data flow components that support multiple inputs cannot use the Advanced Editor.
In the Advanced Editor dialog box, do any of the following steps:
To view and specify the connection that the component uses, click the Connection Managers tab.
Note
The Connection Managers tab is available only to data flow components that use connection managers to connect to data sources such as files and databases
To view and modify component-level properties, click the Component Properties tab.
To view and modify mappings between external columns and the available output, click the Column Mappings tab.
Note
The Column Mappings tab is available only when viewing or editing sources or destinations.
To view a list of the available input columns and to update the names of output columns, click the Input Columns tab.
Note
The Input Columns tab is available only when working with transformations or destinations. For more information, see Integration Services Transformations.
To view and modify the properties of inputs, outputs, and error outputs, and the properties of the columns they contain, click the Input and Output Properties tab.
Note
Sources have no inputs. Destinations have no outputs, except for an optional error output.
View or modify the property values.
Click OK.
To save the updated package, on the File menu, click Save Selected Items.