I am facing the same problem, I changed the datatype of column to varchar for upsert to work, not sure whether its the correct solution.
I wanted to avoid mapping, because my pipeline is parameterized for different tables.