XML Transformation Dynamic Action

About XSLT

XSL stands for EXtensible Stylesheet Language and is a style sheet language for XML documents. XSLT stands for XSL Transformations.

Using XSLT

XSLT provides an easy way of transforming XML data into a standard format. XSLT can be applied during loading the data or in the latest version of Advanced ETL Processor and Visual Importer ETL using package action

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

Variables tab

The Variables tab defines the variables to be updated during the action’s execution.

Execution log tab

The Execution log tab is populated after the action is executed. Double click on the row to view the log.

Calculated XML File Name example

Pascal

begin
 Result:='c:\support\'+LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8)+'.xml';
end;

Python

from datetime import datetime
Result.Value='c:\\support\\'+ datetime.now().strftime('%Y%m%d')+'.xml'

Related Actions

1. XSD Validation Action
2. XSLT Transformation Action

Useful Links

• Advantages and disadvantages of working with XML
• ETL and XSLT
• Debugging Actions
• Working With Variables