Problem Running an Update Query
Posted: 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
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