Definition

Specify a label for this task.

Specify the path and file name of the XML file to read.

Specify the name of a variable of type File List which contains XML files to read. For example, ${variableName}

Specify how the leading and trailing white spaces in the fields should be trimmed. This setting may also be overridden by the individual columns.

Specify the value that should be interpreted as null when reading the data from the input files. If the data in any column in any row matches the value specified here, it will be interpreted as a null. This value can be overridden by the individual columns.

Specify whether or not to skip records that contain unparseable data. The default is 'false' which will throw an error and stop the task.

Specify the format of the number fields (tinyint, smallint, int, bigint, real, float, double, decimal and numeric) in the XML file being read. For e.g. ###,### (2,345) or $###,###.00 ($2,345.46). This value can be overridden by the individual columns.

Specify the format of the date fields in the XML file being read. For e.g. MM/dd/yyyy (08/02/2007). This value can be overridden by the individual columns.

Specify the format of the time fields in the XML file being read. For e.g. hh:mm:ss a (08:12:56 PM). This value can be overridden by the individual columns. Default Value: HH:mm:ss

Specify the format of the timestamp fields in the XML file being read. For e.g. MMM dd, yyyy hh:mm:ss a (Aug 02, 2007 08:12:56 PM). This value can be overridden by the individual columns.

Specify the locale to which the locale sensitive data such as numeric and date/time data is formatted. The locale must be of the form [language]_[country], where language is the two character ISO language code and country is the two character ISO country code. The country part may be omitted if the data was formatted to just the specified language. Example locales are - en_US (English/United States), de (German). If needed, the locale may be overridden on the individual columns.

Specify the type of validation to be performed. By default, validation is 'none' which means no validation is performed. Valid options are - none, schema, dtd

Specify the URL path to the schema source. Use this attribute only if the schema source to validate against is not already defined in the XML document, or to override the schema. Leaving this value blank will validate the document against the schema defined in the XML document. This attribute is ignored if validation is not set to schema.

Specify the action to take when a validation error occurs. By default, all validation errors will be logged to the job log and the project will continue. Note that any fatal errors encountered by the parser means that the XML document is unreliable and the project will fail regardless of this setting. Valid options are - ignore, log, error

If desired, specify the name of a variable which will contain the processed input files. The variable will be of type File List and may be used in subsequent tasks that accept a File List input variable. The variable will be created if it does not exist.

The version of this task.

Specify the level of logging to use while executing this task. Valid options are - silent, normal, verbose and debug.

Specify a condition that must be satisfied before this task can be executed. This task will be skipped if the specified condition is not met.

Whether or not this task is disabled.

Specify the action to take when this task errors out. Valid options are - abort, continue, call:[module] and setVariable:[name]=[value]. For call:[module] replace [module] with the name of the module in the project (e.g. call:ErrorModule). For setVariable:[name]=[value] replace [name] with a variable name and [value] with the variable value (e.g. setVariable:error=true).