DSXchange

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??

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

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