Average: 3.5 (2 votes)


Overview

Script task to transform an XML document using XSLT configuration 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).

Requirements

Depends on System.Xml.Xsl.XslCompiledTransform for XSLT transformation.
Depends on COZYROC Script Task Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.XML

ScriptMain