DSXchange

Hi Gurus,
its urgent plz help me out from this situation.

when i run my job the link for the target file shows 52,230 and it ran succesfully. so no problem with the stage.

But when i tried to view data ...i am getting an error read_fixedwidth()-row 20,column secondary_address ,column unexpectedly ended by EOR.

I tried to change the contain terminators to yes and no .....tried in both ways but no luck so plz help me out from this situation.

thnks in advance

Welcome Aboard
Please dont use words like 'ASAP' and 'urgent' as this is an all volunteer site and folks respond to their convenience.
Having that said, please be informed that the search utility of the website is very powerful and will get answers pretty quick. Please search on keywords column unexpectedly ended by EOR. This topic has been covered before.

Read the message carefully.

Check the data to ensure that there are no embedded newline characters.

Check the job log for "import failed" warnings. Use reject links to capture such rows.

When you posted it was 2:43am in my current location, and I was sleeping. You made no case for urgency. If you want anyone to respond 24x7 it's going to cost you megabucks! Ask about the cost of premium service from your support provider.

There's an old saying - lack of planning (training, experience) on your part does not constitute an emergency on my part.