question

KeshaShah-3519 avatar image
0 Votes"
KeshaShah-3519 asked ZoeHui-MSFT answered

SSIS is not inserting all rows in OLEDB destination

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.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @KeshaShah-3519,

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





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.