SSIS Dataflow Task issue, moving data from any Source to MySQL via ADO.Net

Hossein Kazemian 0 Reputation points
2024-06-12T06:39:54.16+00:00

Can you please help me in getting this problem solved..

I'm trying to build a SSIS package where I'm moving the data from any Source to MySQL. However I'm getting a weird problem in dataflow task.

[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: ERROR [HY000] [MySQL][ODBC 8.4(a) Driver][mysqld-5.5.5-10.4.32-MariaDB]No data supplied for parameters in prepared statement

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (2) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (9). 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.

Please help...

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,756 Reputation points
    2024-06-13T07:13:58.94+00:00

    Hi @Hossein Kazemian，

    ERROR [HY000] [MySQL][ODBC 8.4(a) Driver][mysqld-5.5.5-10.4.32-MariaDB]No data supplied for parameters in prepared statement

    Are you use parameters in your source and destination?

    The error thrown from Mysql side, please have a check you set the destination correctly.

    Here is a sample to use SSIS to load data to Mysql, you may take a reference to.

    How to Load Data From SQL Server to MySQL in SSIS Package Step by StepRegards，

    Zoe Hui

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