SSIS 2008 ADO.NET Destination

SSIS 2008 ADO.NET Destination

Postby rogomax » Wed 17 Sep 2008 08:48

When testing SSIS 2008 ADO.NET Destination with PostgreSQLDirect.NET, I always face an error. Has some had success on that ? (ADO.NET Source is OK).

Error is following :

[ADO NET Destination [139]] Error: An exception has occurred during data insertion, the message returned from the provider is: La référence d'objet n'est pas définie à une instance d'un objet.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (139) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (142). 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.
rogomax
 
Posts: 4
Joined: Wed 17 Sep 2008 08:42

Postby acadalzo » Thu 20 Nov 2008 12:49

I have the exact same problem with dotConnect for MySQL, except my error message is in English. :) Were you able to find a workaround?

Thanks,
Al
acadalzo
 
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Postby AndreyR » Thu 20 Nov 2008 12:56

Try to append ";ANSI_QUOTES" to the value of MySQL server variable SQL_MODE and notify us on the results.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby acadalzo » Mon 24 Nov 2008 10:26

Andrey,
I set sql_mode to ANSI_QUOTES but that did not fix the problem. I will post it to the dotConnect MySQL forum.
Thanks,
Al
acadalzo
 
Posts: 17
Joined: Fri 26 Sep 2008 08:00

Postby AndreyR » Tue 25 Nov 2008 13:52

Rogomax, could you please provide a test project illustrating the problem?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for PostgreSQL