ADO NET Destination Error in Visual Studio 2008 SSIS package

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

ADO NET Destination Error in Visual Studio 2008 SSIS package

Post by acadalzo » Fri 26 Sep 2008 08:27

MyDirect.NET version 4.85.35
Visual Studio 2008 SSIS
[ADO NET Destination [294]] Error: An exception has occurred during data insertion, the message returned from the provider is: Object reference not set to an instance of an object.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (294) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (297). 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.

Shalex
Devart Team
Posts: 8079
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 26 Sep 2008 10:23

Could you please send me a small test project (or provide us with the steps we should follow) and the script that creates the tables and fills them with data? We will try to reproduce the error.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Thu 02 Oct 2008 14:50

FYI, I upgraded to version 4.85.36.0, but no improvement. Thanks.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Thu 02 Oct 2008 14:56

I sent you a small test project. Did you receive it? Thanks.

Shalex
Devart Team
Posts: 8079
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 03 Oct 2008 13:33

Thank you for your letter. We could not reproduce the mentioned error. Please provide me (alexsh at devart.com) with the steps for reproducing this issue, maybe even with screenshots. That will help us locating the trouble.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Thu 16 Oct 2008 15:12

Hi Alex,
I CC'd you on an email to mysqlnet@devart.com. It includes a screenshot. Thanks.

Shalex
Devart Team
Posts: 8079
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 17 Oct 2008 14:40

The problem is inside the SSIS.

The quoting character is hard-coded to " and cannot be changed. We will investigate the possibility of bypassing this problem.

As a hotfix you can manually append ",ANSI_QUOTES" to the value of "sql_mode" variable of your MySQL server instance.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Sat 18 Oct 2008 18:25

Thanks. I will use that workaround. It fixes the "Object reference not set to an instance of an object" error when targeting a version 5.1.23 server.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Wed 26 Nov 2008 19:26

I upgraded to dotConnect for MySQL version 5.0.12.0 and the workaround no longer fixes the problem. Has the workaround been tested using the new version? I will send you my project.

Thanks,
Al

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 27 Nov 2008 10:58

Thank you for the report. We have reproduced the issue and now we are investigating it.
This time error is more serious, so unfortunately no timeframe can be provided. We will notify you about the results.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Thu 11 Dec 2008 12:40

Any progress on this issue yet?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 12 Dec 2008 08:33

The described problem is fixed in the current build.

acadalzo
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Post by acadalzo » Mon 15 Dec 2008 22:05

Thanks Andrey. I installed the latest build and it works for me now (using the 'ANSI_QUOTES' workaround).

Post Reply