Loading Boolean values into Salesforce using Connector

tradersjoe57 · Post by **tradersjoe57** » Wed Nov 09, 2016 4:03 pm

Sales force Object has Boolean data type fields which need to be loaded using Datastage.While trying to import the field definitions of object using Sales force connector, it defaults to Varchar data type fields.

I have manually changes the data type to Bit and tried to load the object, but all the records were rejected because of data type mismatch.

Any help is much appreciated!!

tradersjoe57 · Post by **tradersjoe57** » Thu Nov 10, 2016 9:51 am

Write them as varchar values. It worked!

chulett · Post by **chulett** » Thu Nov 10, 2016 10:32 am

Interesting... thanks for posting your resolution.