Advanced Editor (Input and Output Properties Tab)

Use the Input and Output Properties tab of the Advanced Editor dialog box to set input and output properties for the selected Integration Services object. Also use this tab to add and remove outputs, select or remove columns for inputs and outputs, and set properties for inputs and outputs.

The Advanced Editor is available for most Integration Services objects that have configurable properties. It is the only editor available for those objects that do not expose a custom user interface.

Integration Services 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 tab
  • Component Properties tab
  • Column Mappings tab
  • Input Columns tab
  • Input and Output Properties tab

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 Integration Services Objects and Concepts documentation:

See Also


Advanced Editor (Connection Managers Tab)
Advanced Editor (Component Properties Tab)
Advanced Editor (Column Mappings Tab)
Advanced Editor (Input Columns Tab)

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance