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
varchar in transformer, bit in MSsql
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Tue Feb 26, 2013 9:36 am
- Location: Chicago
Bit Datatype can accept 0 or 1
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.