Scheduler task: Import ETL Package

This task imports data into Axiom Software (same as executing an import from the Imports menu).

NOTES:

If the import package is configured to Ignore lookup and key errors, then if errors are found the execution status of the job will be Partial Success. This will trigger an email notification if the job is configured to notify only on error.
If you want to use the "file watcher" functionality to automatically trigger an import to run when a source file is placed in a designated folder, see Using file watcher to trigger imports.

Item	Description
Select ETL Import Package	The import package to process. You can select any import that is defined in the current system.
Source Filename	The path and name of the source file. This option only applies in the following situations: The import is configured to pull data from a source file (instead of a database table). The import is configured to prompt the user for the source file during execution. If the import is configured to always use the same source file, then that file displays for reference in the Source Filename box, but it is grayed out and cannot be changed. NOTE: If you are configuring the import to use file watcher, enter the predefined variable {fullpath}. Job variables can be used in this setting.
Package Variables	Specifies values for any variables used in the import package. Variables are listed in the right-hand side of the grid. Use the drop-down list next to the variable name to select from the defined set of choices, or type in a value. Job variables can be used in this setting.

Item

Description

Select ETL Import Package

The import package to process. You can select any import that is defined in the current system.

Source Filename

The path and name of the source file. This option only applies in the following situations:

The import is configured to pull data from a source file (instead of a database table).
The import is configured to prompt the user for the source file during execution.

If the import is configured to always use the same source file, then that file displays for reference in the Source Filename box, but it is grayed out and cannot be changed.

NOTE: If you are configuring the import to use file watcher, enter the predefined variable {fullpath}.

Job variables can be used in this setting.

Package Variables

Specifies values for any variables used in the import package.

Variables are listed in the right-hand side of the grid. Use the drop-down list next to the variable name to select from the defined set of choices, or type in a value.

Job variables can be used in this setting.