Difference between Insert Outputmessage and Tablerecords

[mungerboeck]

Hi,

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.

Thanks.

[Anonymous]

Hi,

Have you already checked that if there are some rows rejected by your tMSSqlOutput?

Best regards

Sabrina

[mungerboeck]

Yes, but there are only 600 rows rejected.

[Anonymous]

Hi,

Would you mind posting your current job design screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

[mungerboeck]

Hi Sabrina,

here you can see my job.

[cterenzi]

Hi @Mungerb, that doesn't appear to be a screenshot of your Talend job.  Could you repost, please?

[mungerboeck]

Sorry, here is the right job.