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.