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

There are currently two types of SSIS 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-based 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.

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