+ Start a Discussion
Arvind1Arvind1 

URGENT HELP in DataLoader Please Please

Hi,

 

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.

 

Thanks

 

start_s1start_s1

Hi,

 

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