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
