August 29, 2013 at 11:34 am
I have an SSIS package that is connecting to a database using an ODBC connection.
The connection is setup and tests successfully. If I create a simple Execute SQL Task and run:
select top 1000 *
from
[MyTableData] where DateEntered >= GETDATE()-45
it runs fine. If I run:
delete
from
[MyTableData] where DateEntered >= GETDATE()-45
Then I get this:
failed with the following error: "Error HRESULT E_FAIL has been returned from a call to a COM component.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Any ideas? The connection must be fine because it will do a select just fine, but it won't delete.
December 15, 2015 at 6:13 am
Hello!
I had the same problem, to solve i changed the my ODBC conection to ADO.net conection.
I hope that works for you.
Bruno Silva
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy