Overview
Script task to transform an XML document using an XSLT file.
Setup
The script has the following parameters:
- IsTransformVariable - if true, transformation file path is contained in package variable. Otherwise it is file connection manager (Boolean).
- TransformVariable - transformation file path package variable (String).
- Transform - transformation file connection manager (connection).
- IsSourceVariable - if true, source file path is contained in package variable. Otherwise it is file connection manager (Boolean).
- SourceVariable - source file path package variable (String).
- Source - source file connection manager (connection).
- IsTargetVariable - if true, target file path is contained in package variable. Otherwise it is file connection manager (Boolean).
- TargetVariable - target file path package variable (String).
- Target - target file connection manager (connection).
Configuration
To use this script, you would need to load it in COZYROC JavaScript Task. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Transform_XML_Task.jsKnowledge Base
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.