ssis varbinary column removing first 2 hexadecimal values

 

if any of the columns are varbinary and if you are exporting the data into a text file, by default ssis

will remove the first 2 letters ox. to troubleshoot this below technique will help.

first convert the filed to varchar and then use the query inside a cte to avoid the problems with type

conversion in ssis

with cte as ( select col1,col2, CONVERT(varchar(max), col3, 1) as col3 from mytable ) select * from cte