AX2563

Scheduler task: Import ETL Package

This task imports data into Axiom Budget Planning and Performance Reporting (same as running an import from the Imports menu).

NOTE: If the import package is configured to Ignore lookup and key errors, and errors are found, the run status of the job will be Partial Success. This will trigger an email notification if the job is configured to notify only on error.

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 runtime.

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

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 side of the grid. Use the dropdown next to the variable name to select from the defined set of choices, or enter a value.

You can use job variables in this setting.