Unable to read data from file

[boppanakrishna]

Hi

I am reading data from flat file and i am receving null values in date field from the source. When i am converting data from string to date in sequential file stage, i am getting following error.

Data string '#00010#A' does not match format '%yyyy%mm%dd': an integer was expected to match tag %yyyy

## i don't want to read data using varchar data type. because i want to reject the data if it does not contain a valid data.

Can you please let me know if you have any idea about this.

Regards
Ramu

[jwiles]

"#00010#A" (your incoming data in the flat file date column) does not match the format specification you provided.

Do you have a reject link from your sequential file stage? What have you set the Reject Mode option to? The Parallel Job Developer Guide documentation for the Sequential File stage lists the Reject Mode options.

Regards,