varchar in transformer, bit in MSsql

[smohd1338]

Hi ,

I tried ti find the answer by searching in the fiorum but was in vain,

I have thsi varchar(1) in transformer, and Bit in database table, which conversion whould i need to use

[sudha03_vpr]

Bit Datatype can accept 0 or 1. You can probably check the data in the varchar field. If its 0 / 'T' (representing True) then you can probably hardcode 0 else 1.