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
Workflow tab
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.
It is usually used for debugging and not recommended for production environment.