import error and no default value

[mallikharjuna]

Hi,

I am reading '|~|' delimited .csv file data. job is working fine and able to read all the records but i am getting the below warning message

"Field "Site_ID" has import error and no default value; data: {S i t e - I D}, at offset: 24:"

please let me know if any changes required in sequential file properties.

Thanks
Mallikharjuna Reddy

[asorrell]

Do a search for "has import error and no default value" - been answered dozens of times.

[ray.wurlod]

It should be obvious from the values in the error messages that the error is occurring in the first row and it's trying to read the column headings as data. This is because of a property in the Sequential File stage that has not been set properly. Let us know that you've found the property in question and fixed your problem.