Transform XML Task

Your rating: None Average: 1.5 (2 votes)

Overview

Script Task to transform an XML document using XSLT configuration file. It providers 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 component for implementing parameters user interface.

Library references

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

ScriptMain