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. You can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Transform_XML_Task.jsReady to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.