Posted: Wed Oct 03, 2007 5:14 am
Check whether you had specified correct delimiter. Also did you load the metadata from the repository?
check your source file, perhaps it was created on windows and by default datastage reads unix files.
double click on the inputfile, click on format tab and select Record Delimiter String and then select DOS format. it should fix your problem.
it is because of the extra character in dos.