Getting error when delete the able donot have data

• asrinu13

  Say Hey Kid

  Points: 709

  More actions

  June 5, 2020 at 7:37 am

  #3760731

  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

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 6, 2020 at 8:10 am

  #3761016

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.