Hi,
We have a situation.
The source is a comma separated text file with data as below:
Country,dDate,ENm
US,2016-06-22,Smith
UK,2015-03-03,John
US,2016-15-10,Rose
We are trying to read the data using a sequential file. Tried 2 approaches:
Read everything as varchar and then used IsValidDate along with String to Date conversion. This gave warnings "String to Date Conversion".
Read the date field as Date and added a reject file to the sequential file. It rejected the data but gave a warning "field has import error and no default value".
The requirement is to reject the records with bad date and pass on only the clean data without warning.
Is there a way to achieve this?
Thanks.
Identify Invalid Dates
Moderators: chulett, rschirm, roy