NEW: Check our new hosted service COZYROC Cloud ...
Script Transform XML Task
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.jsReady to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.