SSIS Set Variable Transform

SSIS Set Variable Transform can parse JSON string into multiple columns and rows (Helpful to extract data from raw JSON string stored as database column or coming from other source).

Features

Quickly set SSIS variable inside Data Flow without scripting.
Support for Append mode (Append each input value using custom Row Seperator and Last Row Seperator).
Support for Increment Counter Mode (e.g. Row Counter) with custom IncrementBy number.
Support for Sum Column Value Mode.
Support for Replace Placeholder mode (e.g. You can have template string and replace <%value%> with upstream value.
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

SSIS Set Variable Transform configure

In the Component Properties, you can select Various VariableSetMode Property, and select Variable in VariableToSet we have created before

Next move on Input Columns Tab, select columns

SSIS Set Variable Transform – Input Columns Tab

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.