Page 1 of 1

varchar in transformer, bit in MSsql

Posted: Tue Feb 26, 2013 5:03 pm
by 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

Bit Datatype can accept 0 or 1

Posted: Wed Feb 27, 2013 12:54 pm
by 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.