Parameters: ETL task

To create a new parameter, click the Add button. The parameters will be added to the end of the list and will be selected.

Set parameter attributes:

Type/Data Type. Select one of the available data types in the drop-down list.

Name. Enter parameter name.
Identifier. Enter a sequence of Latin letters, numbers, and underscore characters, starting with a letter. An identifier must be unique within the object.
Display Settings. Select appearance and behavior for the parameter value editor. Display parameters are determined as a special string containing editor type, default value, and so on. The string can be edited in the edit box or using the Value Editor Parameters dialog box. To open the dialog box, click the Browse button. By default, display parameter is selected in accordance with the selected parameter type.

NOTE. Setting up parameters visibility is available if in the value editor a custom name is set.

Default Value. Set parameter default value if required. Features of default value for the following data types:

String. It may contain up to 2 GB of data. String text is specified without quotation marks.
Integer. An integer number is allowed in the range [-2147483648; 2147483647].
Decimal. A decimal number with no more than 28 places after the point in the range [-179228162514264337593543950335; 179228162514264337593543950335].
Real. A real number is allowed in the range [-5.0 x 10-324; 1.7 x 10308].
Date. Minimum date - 1 January 100 year (AD) 00:00:00, maximum date - 31 December 9999 year (AD) 23:59:59.
Custom. A set of unstructured data is allowed that is an array of binary or character data. Values of parameters that have a custom data type can be passed only when working with an object in application code.

If dictionary box editor is used, the following becomes available: element selection, changing selection by criterion and setting up of displaying of element names. To work with these functions, use context menu items.

To change displayed properties, select or deselect the required properties in the drop-down menu of the Settings button.

To change the parameter settings, click the corresponding column. Select data type in the drop-down list. The editor, in which one should set value, will be activated by default for name, identifier and value. To set up displaying, click the Set Up Display button. The display setup dialog box opens.

To delete the parameter, select it in the list and click the Delete button. To delete several parameters, select their checkboxes in the first column and click the Delete button. After operation confirmation the parameters are deleted.