+ Start a Discussion

URGENT HELP in DataLoader Please Please



I have to load data from SAlesforce.com to SQL server on daily basis.

I have used dataloader(using config files) connected to SQL server.

I have some date fields in extraction of SFDC which needs to be loaded to SQL server.


While loding am getting error has error sql:conversion from date and\or time to string converiosn.


I tried with the following values.


<entry key="DATEOFBIRTH"        value="java.lang.String"/>
<entry key="DATEOFBIRTH"        value="java.util.Date"/>


Please help in this.







try to use the following:


<entry key="DATEOFBIRTH"        value="java.sql.Date"/> 


Hope it will help.

Message Edited by start_s1 on 02-26-2010 05:05 AM