SSIS Data Transfer Discrepancy: Missing Rows When Transferring from MySQL Source to Destination using SSDT 2017 on Windows Server 2019

Question

I'm using SSDT 2017 with an SSIS package on a Windows Server 2019 machine to transfer data between two MySQL (MariaDB) databases. I connect to the sources using a VPN on the server. For one specific table, the source has around half a million rows, but after the transfer, the destination only shows around 270k rows. Despite this discrepancy, there are no error messages.

Has anyone encountered a similar issue or can provide guidance on how to troubleshoot and resolve this discrepancy?

Answer 1

Hi @Bharath Vadlamannati，

Check the Error Output (under Connection Manager and Mappings) within Destination Component. If the Error setting is set to Ignore Failure or Redirect Row, the component will succeed, but only the successful rows will be inserted.

And also check the destination file and make sure it could store the acceptable number of rows.

You may also preview the source data to ensure the Connection Manager Source has no issue.

Regards，

Zoe Hui

---

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