SSIS Template Transform

SSIS Template Transform can be used to create dynamic strings inside data flow. You can use upstream columns as placeholders or use SSIS variables anywhere in the template to create desired text (e.g. XML / JSON document).

Features

Generate string / documents (e.g. JSON / XML ) from SSIS Variable and Upstream columns
Support for many placeholder functions
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

In Visual Studio, drag and drop the ZS Template Transform in the design panel

In Visual Studio, drag and drop the OLEDB Source, ZS Template Transform and ZS Web API Destination in the design panel

SSIS ZS Template Transform configure to create desired API call

Configure SSIS ZS Template Transform to create desired API call

Articles / Tutorials

Click here to see all articles for [SSIS Set Variable Transform] category

How to convert Varbinary to Base64 in SSIS

Introduction In this post we will show you how to convert varbinary to Base64 in SSIS. We will use FREE Tasks provided by ZappySys. Preparing Sample Data First let’s create a sample table with some Varbinary datatype. Run following command in SSMS to create a sample table with one sample row.