I'm reading in one SQL table and doing a lookup against another SQL table which is an identical copy of the first table, used for temporary storage during the load event.
I want to compare each field to find if there are any changes in the temporary table. When I compare two string fields, Customer != temp_Customer I get no error message. When I compare two decimal fields, Width != temp_Width I get an error message: DT_WST
and DT_Numeric are incompatible with !=.
The two fields are BOTH declared as decimal 19,6 in their respective tables. Why can't I run this comparision???
View Complete Post