SSIS is not inserting all rows in OLEDB destination

Question

Hello everyone,

I have one SSIS package which moves data from one SQL Server to another SQL Server after applying certain transformations and then upsert is been performed.

The issue with the package is- when I run the package,SSIS shows the exact no. of rows inserted into destination and complete successfully. But when I checked the destination table, I could not find a few records. Not sure where they are gone. Need help in resolving this situation.

Answer 1

Hi @Kesha Shah ,

First please check whether there are any other processes that might trigger some action on your destination table (either from within the package or outside of the package).

Have you tried to insert into a new table for a try? This might help to narrow down the issue.

In addition, try to set the DataFlow setting AutoAdjustBufferSize--True.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October