Overview
Template Component is SSIS Data Flow Component providing ability to setup data flow output text columns, based on other input columns and package variables and a template. The template definition is based on Apache Velocity engine.
Parameters
Configuration
The configuration dialog consists of three parts:
- Grid to define result columns.
- Variables and column reference tree.
- Template definition editor.
Select result column type. This property has the options listed in the following table.
Value Description <add as new column> A new output column is setup for result. Replace '...' Selected existing input column is replaced with the template result. Specify result column name.
Build a template that uses a variable or an input column by dragging the variable or column from the list of available variables and columns to the template edit window.
Specify result column template. The value of this property can be specified by using a property expression.
Knowledge Base
- Where can I find the documentation for the Template?
- What is the difference between Template Task and Template Component
- How can I dynamically modify a transformation in an SSIS Data Flow Task?
What's New
- New: Support for #evaluate directive.
- New: Introduced component.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.