Template Merge Components are SSIS components that allow developers to use column data to generate various file types.

There are currently two types of SSIS template merge components within this category. One will facilitate the merging of column or variable data into a text template, the other into an HTML template.

The following are the Template Merge components available within the SSIS Productivity Pack and the link to their Help Manuals:

  • HTML Template Merge
    • This SSIS transformation component allows developers to merge column and variable data into an HTML template through a WYSIWYG or source editor.
  • Text Template Merge
    • This SSIS transformation component allows developers to merge column and variable data into a text template.

Video Resources

Youtube Video - Getting started with SSIS Productivity Pack - HTML Merge

Youtube Video - Getting started with SSIS Productivity Pack - Text Merge