SSIS Set Variable Transform Archives

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 […]

Category Archives: SSIS Set Variable Transform

How to convert Varbinary to Base64 in SSIS