Four Stars

Difference between Insert Outputmessage and Tablerecords

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.

 

6 REPLIES
Moderator

Re: Difference between Insert Outputmessage and Tablerecords

Hi,

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

Best regards

Sabrina1.png

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Difference between Insert Outputmessage and Tablerecords

Yes, but there are only 600 rows rejected.

Moderator

Re: Difference between Insert Outputmessage and Tablerecords

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Difference between Insert Outputmessage and Tablerecords

Hi Sabrina,

here you can see my job.

Ten Stars

Re: Difference between Insert Outputmessage and Tablerecords

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

Four Stars

Re: Difference between Insert Outputmessage and Tablerecords

Sorry, here is the right job.

 

job.JPG