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

Bharath Vadlamannati 0 Reputation points

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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 25,301 Reputation points

    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.


    Zoe Hui

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

    0 comments No comments