Convert Varbinary to BASE64 using SSIS Template Transform

How to convert Varbinary to Base64 in SSIS

Posted on January 30, 2019January 30, 2019 by ZappySys

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.

create table binarydata(
 data varbinary(max)
)
go
insert into binarydata(data )
values(0x5468697320697320612074657374) /*binary of "This is a test"*/

create table binarydata(

data varbinary(max)

)

insert into binarydata(data )

values(0x5468697320697320612074657374) /*binary of "This is a test"*/

Method 1 […]

SSIS Base64 Encode, Decode using SSIS Logging Task (Without coding convert plain text to base 64 string)

SSIS Base64 Encode Decode without Coding

Posted on September 7, 2016September 5, 2023 by ZappySys

Introduction In this post you will learn how to use FREE SSIS Logging Task to perform ssis base64 encode decode and save to Variable or File (i.e. convert Base64 Encoded value to plain text or encode plain text to base64) . You can also use many other format specifiers found here How to invoke Placeholder […]

Calling REST API in SSIS with Basic Authentication / Userid-Password (BASE64 Authorization header)

Posted on August 27, 2015September 8, 2023 by ZappySys

Introduction In this blog post you will explain how to pass basic credentials (i.e. UserID/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume / call REST API in SSIS check this article. HTTP Authorization Header […]