insert count is more than the table record count

[sbxr]

Hi,

when i am loading some source data the count of insert which is showing in the job is 12344 but when i check in target table it is 12340 why so?

Tagert is Mssqloutput.

Regards

[Anonymous]

Hi,

I had the same problem with an Hive table.

My source was a database but the data was not cleaned yet, meaning it could have line breaks (\n , \r or \r\n).

You should replace these values. I would recommend to investigate your source.

Kr,

Jvl7

[Anonymous]

Hello,

Please try to get the rejects link when right click the out put component to see if there are rows rejected by your Mssqloutput component?

Best regards

Sabrina

[Anonymous]

Hello,

Make sure that you un-check the "Die on error" option to enable it and for MSSQlOutput, the "Use Batch Size" in the Advanced Settings of component should also be unchecked. Then the rejects link can be chosen.

Best regards

Sabrina