We insert with tMSSqlOutput a table with more than 5 Mio records. The targetable is empty.
In the Log-File we can see that these 5 Mio records are inserted (these Information come from tMSSqlOutput_2_NB_LINE_INSERTED).
In the targettable there are only 800.000 records.
When we start the job in Talend directly, you can see, that 5 Mio records are proceeded and inserted. But in the targettable it's the same problem.
The action on tMSSqlOutput is only insert and we use a reject path. But there are only 600 records.
Our Talendversion is 6.0.1 and the Database is a MSSql.
Can anyone help me.
Have you already checked that if there are some rows rejected by your tMSSqlOutput?
Would you mind posting your current job design screenshots on forum which will be helpful for us to address your issue?