Logical connections display in the

Shared Connection Details

area.

If the logical connection is associated with multiple objects, select the logical connection, and then select each object.

If the logical connection is associated with objects on other pages of the wizard, be sure to use the same connection for logical connections with the same name.

This displays when a lookup requires a connection or object and the lookup is configured to display on this page. If you need to select a lookup object, select the object from the list. If a list of objects does not appear, click

Select

.

For some connection types, click

Advanced

to configure advanced properties for the connection. For more information, see

Connections

.

For some connection types, you can select

Display technical field names instead of labels

to display technical names instead of business names.

To display fields in alphabetical order, click

Display lookup fields in alphabetical order

.

This displays when a mapplet requires a connection and the mapplet is configured to display on this page.

For some connection types, you can select

Display technical field names instead of labels

to display technical names instead of business names.

To display fields in alphabetical order, click

Display mapplet fields in alphabetical order

.

This displays when a stored procedure requires a connection and the stored procedure is configured to display on this page.

String template parameters display individually based on the Visio template. The following table describes how to define a string template parameter based on the input control type:

Input control type	Description
Text box	Enter any valid value. You cannot use blank spaces. Also, leading and trailing spaces are removed at run time.
Data filter dialog box	To define the template parameter, click New . To create a simple data filter, in the Data Filters dialog box, select a column and operator and enter the value you want to use. To create an advanced data filter, click Advanced . Enter the field expression that you want to use, and click OK . If the template parameter is already defined with a data filter, delete the existing data filter before creating a new data filter. For a template parameter included in a source filter, use an advanced data filter.
Field expression dialog box	To define the template parameter, click New . In the Field Expressions dialog box, enter the expression you want to use and click OK . For more information about configuring field expressions, see Field expressions.
Field list	To define the template parameter, select a field from the list.
Field mapping dialog box	To define the template parameter, configure the field mappings you want to use: The left table can display fields from sources, mapplets, and lookups. The right table can display fields from multiple targets, as well as mapplets and lookups. Use the Object list to display fields from different objects. By default, all available fields display. To match fields with the same name, click Automatch > Exact Field Name . Or, to match fields with similar names, click Automatch > Smart Match . You can also select and drag the source fields to the applicable target fields. To clear all field mappings, click Clear Mapping . To clear mapped field, click the Clear Mapped Field icon for the target field. If you map a target field in a task with multiple targets, you also map any matching fields in other targets. A matching field is one with the same name and data type, precision, and scale. If the target fields have the same name but different data types, precision, or scale, you can map one of the target fields. If fields from a lookup do not display, configure the lookup connection and object, save the task, then edit the task again.
Custom Dropdown	To define the template parameter, select an option from the list.