Convert Binary to bit

nishantrk · Post by **nishantrk** » Thu Feb 16, 2012 12:33 pm

Hi,

While extracting data from salesforce to load to sql server 2008 ,
one of the field is defined as "boolean" in salesforce , The definition of the same in sql server table is "bit" .
I was able to get the data from salesforce by defining the field metadata as "binary" ,But how do I convert this to "Bit" to be loaded in Sql server??

DSguru2B · Post by **DSguru2B** » Thu Feb 16, 2012 1:27 pm

Boolean is just a TRUE or FALSE. If you extract as varchar you will see a 0 or 1. Try doing that.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 16, 2012 3:10 pm

Unsigned TinyInt (uint8) is the closest DataStage approximation to Bit.