| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Advanced Editor |
Advanced Editor |
chugugrace |
chugu |
03/01/2017 |
sql |
integration-services |
conceptual |
|
[!INCLUDEsqlserver-ssis]
Use the Advanced Editor dialog box to configure properties for the selected [!INCLUDEssISnoversion] object.
The Advanced Editor is available for most [!INCLUDEssISnoversion] objects that have configurable properties. It is the only editor available for those objects that do not expose a custom user interface.
[!INCLUDEssISnoversion] data flow objects have properties that can be set at the component level, the input and output level, and the input and output column level. The Advanced Editor enumerates all the common and custom properties of the selected object and displays them on up to four of the following five tabs as applicable:
-
Connection Managers -- use this tab to set connection properties
-
Component Properties -- use this tab to set component-level properties
-
Column Mappings -- use this tab to map available columns as output columns
-
Input Columns -- use this tab to select input columns
-
Input and Output Properties -- use this tab to set input and output properties; and to add and remove outputs, select or remove columns for inputs and outputs, and set properties for inputs and outputs
The properties displayed vary by component. For more information on the properties that may be displayed in the Advanced Editor, see the following topics:
For more information about the specific component that you are editing, see the description of the component in the Data Flow Elements section of the [!INCLUDEssISnoversion] Objects and Concepts documentation: