I THINK

your flat file content is not arranged as matching to database table, add commas(,) correctly between as shown below .use below edited data as flat file source and try....

*Its considering a whole line as one column and trying to insert which is more than the size of the columns defined in the source and you will enter all the values to single column that's wrong.

*like it will insert emp_no emp_fname emp_lname dept_no,this whole line into emp_no ..which is wrong.

correct flat file source can be:

emp_no, emp_fname, emp_lname, dept_no

25348,Matthew,Smith,d3

10102,Ann,Jones,d3

18316,John,Barrimore,d1

29346,James,James,d2

9031, Elsa,Bertoni,d2

2581, Elke,Hansel,d2

28559,Sybill,Moser,d1

then

use row delimiter = cr-lf

column delimeter= ,(comma)