Share via

Package does not load any rows and there are no errors with MySQL as DS

Beacon77 131 Reputation points
2022-09-14T14:53:58.62+00:00

Hi All,
I have created a package using VS2015 32 bit. Source is MySQL db and I installed and tested the ODBC Connection for 32 bit successfully. Created the connection manager successfully as well. Destination is SQL Server database. The data access mode from MySQL is a SQL Command. When I run the package I do not get any error and also it does not load any rows. When I click on the preview in the source I do not see any data (data exists). When I change the data access mode to Table, in the preview I can see the data , but the package fails with the following error

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "APPS - Weather Station" (41) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (54). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

[MySQL - Weather Data [107]] Error: Open Database Connectivity (ODBC) error occurred.

Please advice.
Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,564 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,116 Reputation points
    2022-09-15T06:20:43.247+00:00

    Hi @Beacon77 ,

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "APPS - Weather Station" (41) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (54).

    From the error message, the error thrown at APPS - Weather Station processing input "OLE DB Destination Input".

    Please have a check if there is a data type issue. You have to match the compatible data type as per the source in APPS - Weather Station.

    Switching the Run64BitRuntime project setting to False to try.

    You may also try with ADO.NET to connect to Mysql to see if it could work.
    https://techcommunity.microsoft.com/t5/sql-server-integration-services/connecting-to-mysql-from-ssis/ba-p/387400

    Regards，

    Zoe Hui

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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.