(S0002/8169) Conversion failed when converting from a character string to uniqueident

I have to insert into an MSSql DB field defined as “uniqueidentifier”. How can I create a unique Nbr or How can I translater a number into the data type “uniqueidentifier”?

(S0002/8169) Conversion failed when converting from a character string to uniqueidentifier." Conversion failed when converting from a character string to uniqueidentifier.

What is the JDBC field input datatype you selected in the insert SQL JDBC template? Integer or lang.string?

JDBC field input datatype I selected lang.string

Where are you seeing that error in the error.log or SQL side?

HTH,
RMg

No comments above: