Hello, I’m attempting to to use table comparison on a target that has a constrained field that is a geometry datatype. I prepare the field to long using varchar_to_long however it seems like the table compare doesn’t like comparing long to the native geometry. I keep getting “Operand type clash: text is incompatible with geometry” errors. I think I can get around this for this particular project because I can separate my dataflows to insert and updates and use map operations, but my preference would be to use the table compare. Wondering if anyone else has encountered a similar issue and how you may have dealt with it. The target database is MSSQL 2012.
The forum is really helpful, Thanks.
seanrec 
(BOB member since 2015-02-19)