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).
|View All Tasks|
Download View All Tasks Like This
ScreenshotsUseful LinksSystem Requirements
SSIS Set Variable Transform configure
Next move on Input Columns Tab, select columns
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.
Click here to learn more about System Requirements