Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query

Help Activities
, , ,
1

Hi all,

Run command: Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.

How to resolve this issue. Please guide me on this.

2

For what activity or function does this issue arise

3

In run command i am getting this error in insert query.
image

4

I think like the error suggests, you have to use the CONVERT function to convert it from varchar to varbinary(max). Check the below link for reference

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query (microsoft.com)

5

The datatype of a column in your insert query doesn’t match the datatype of the column in your database. Show your whole query.

Also, the Insert activity may work better. You’d use Build Datatable to create the correct columns, use Add Data Row to add a row of data to it. Then you’d use the Insert activity and pass the datatable to it.