XSD Validation Dynamic Action

About XSD

XSD stands for XML Schema Definition. It is a specification used to describe the structure and constraints of XML documents. XSD provides a way to formally define the elements, attributes, and data types allowed in an XML document, as well as the relationships between them.

XML Schema Definition (XSD) documents are written in XML format themselves and can be used to validate XML documents to ensure they adhere to a specific structure and content rules defined by the schema.

Using XSD

XSD is commonly used in various contexts where XML data exchange is prevalent, such as web services, data interchange formats, configuration files, and more. It provides a standardized way to define and validate the structure of XML documents, making it easier to develop and maintain XML-based applications.

Metadata tab

XSD Validation 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

XSD Validation Action - Parameters tab
 

Variables tab

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

XSD Validation Action - Variables tab

Calculated XML File Name example

Pascal

XSD Validation Action - Calculated XML File Name example - Pascal
  Script

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

Python

XSD Validation Action - Calculated XML File Name example - Python
  Script

from datetime import datetime
Result.Value='c:\\support\\'+ datetime.now().strftime('%Y%m%d')+'.xml'
  1. XSD Validation Action
  2. XSLT Transformation Action

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on October 12, 2024 • 2 min read • 358 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License