Question

Conversion failed when converting date from character string

  • 31 October 2022
  • 1 reply
  • 51 views

Hi Team

 

am trying to process a file and in that i have date column for which two records am getting date as

 

00000130 and 00000706  the year in date field has value as 0000 which is causing the records to drop the problem is due to this two records streamsets is not processing other good records too if i 1 million in records in file its not loading around 1k records after those two error records 

 

 


1 reply

Userlevel 5
Badge +1

@akanshajain6793 

I believe this error is while loading data to to DB .

Can you please try to convert the string to date format and process data.

 

can I get sample input ,so I can give a try.

 

Thanks & Regards

Bikram_

 

Reply