Import Dynamic Action

The Import action is used to load external data into a system or database. It typically handles the extraction, transformation, and loading (ETL) of data from various sources, such as files, databases, or other formats, into a target system. This action is commonly used in data integration processes to automate and streamline the import of large datasets.

To create a new Import Action, Drag and Drop it from the Object tree.

Metadata tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
2. This option is typically used for debugging and is not recommended in a production environment.
3. It can be globally disabled through the options dialog .

Parameters tab

Selecting Import

Variables tab

The Variables tab defines which variables are updated during the execution of the action.

Execution log tab

The Execution Log tab is populated after the action has been executed. Double-click a row to view the detailed execution log.

Calculated Import example

Pascal

begin
 if DayOfWeek(Now)=3 then
    begin
     Result:=4191;
    end
 else
    begin
     Result:=1968;
    end;
end;

Python

import datetime;
if datetime.datetime.today().weekday()==0:
   Result.Value=1508
else:
   Result.Value=1968

Related Actions

1. Transformation Action
2. Block Transformation Action

Useful Links

• Debugging Actions
• Working With Variables