Post reply

[ODBC Destination [2]] Error: Open Database Connectivity (ODBC) error occurred.

  • April 28, 2021 at 6:32 pm

    #3877021

    I have been moving data succesffuly from SQLServer to Maria DB. Using this string  "DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=bottlesmarketing;UID=Anthony;Password=******"

     

    I am getting these errors trying to move this one table. Please assist?

    [ODBC Destination [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HYC00'. Native Error Code: 0. [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.4.18-MariaDB]Parameter arrays with data at execution are not supported

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

    [OLE DB Source [257]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

     

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on OLE DB Source returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

     

  • April 28, 2021 at 7:09 pm

    #3877044

    From looking at that, the problem is indicated in the first error - Parameter arrays with data at execution are not supported by the MySQL/MariaDB ODBC driver.

     

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply