Hi I have one doubt in ssis
I want delete the data in the target server(postgres) tables data using ssis package.
database : postgres server
Table : emp
in execute sql task :scriptis: delete from emp and connection used odbc
when i run the executesql task in ssis package
if emp table have data then its working fine and i am getting the error when emp table donot have data.
[Execute SQL Task] Error: Executing the query "delete from emp
usin..." 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.
suppose if i run same query in pgadmin tool that time it is not getting any error even though emp table donot have data.
could you please tell me how to avoid this issue in ssis package.
when emp table donot have data: if I run delete query its working fine without error and same query running using execute sql task its failed.could you please help on it