How to Load Varchar data in VarBinary Column in SQL using BODS?

[Former Member]

Hi,

I am getting error while loading data from var-char source column to var-binary column from SQL target database.

Its saying to use CONVERT functions, so please help.

Thanks

Parijatam

[Former Member · Accepted solution]

As per Data Services reference guide, the conversion from varchar to varbinary(SQL Server Target data type) is not supported.

1752227 - What are the Data Type conversions for Microsoft SQL Server - Data Services

Regards

Arun Sasi