Share via

While Deleteing records in PG,giving error using SSIS

qasimidl 106 Reputation points
2023-08-08T13:44:42.7233333+00:00

Hi,

I am using SSIS with visual studio 2022 and sql server 2017.

Problem:

Using PG Database, want to delete records of tables using below query, ( I am using ODBC connector for database)

DELETE FROM st_ht.inded where theday = '2021-08-09'.

above query is working fine on PG , but as I execute query in SSIS using "sql execute task", its giving below error.

Error:

Execute SQL Task Error: 0xC002F210, Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly

Note: if I replace delete query with Select, it works.

PFA deletePG.PNG

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
Developer technologies Visual Studio Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. qasimidl 106 Reputation points
    2023-08-11T07:37:45.4366667+00:00

    resolved, by adding begin and commit section in query like

    begin

    query

    commit.

    it works.

    Thanks

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.