Wim,

What is the datatype of TotalAmount? It looks like you try to move a string/literal into this column.

Hint: In DF and DR tryout the SQL statement in the native tools (e.g. SSMS)