Problem Running an Update Query

Problem Running an Update Query

Postby fionajh » Tue 18 Sep 2007 17:35

I have created a SQL Server 2005 Integration Services task which runs an update query on a table in a MySQL database - I get an error when I run it, although the query appears to do what it should.

The query is: update tblorderstatus inner join tbltemporder on tblorderstatus.franchiseeid = tbltemporder.franchiseeid and tblorderstatus.orderdate = tbltemporder.orderdate set tblorderstatus.orderstatusid = 99, tbltemporder.exportdate = now() where tblorderstatus.orderstatusid = 4

The error is: Error: 0xC0024104 at Set Flags and Export Date: The Execute method on the task returned error code 0x80131509 (This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.). The Execute method must succeed, and indicate the result using an "out" parameter.

Any body any ideas how I can stop this happening as it makes the job fail
Posts: 1
Joined: Tue 18 Sep 2007 17:30

Postby Alexey » Wed 19 Sep 2007 08:08

Please describe in detail how you create that task.
Could you send me a test project to alexeyi at crlab dot com?
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for MySQL