CODEWITHSUNDEEP
postgresqlssis
OutOFTouch
OutOFTouch

Reputation: 1077

How to execute a SQL statement against PostgreSQL using SSIS?

I can't seem to figure out how to execute a sql statement like for example truncate table against a postgresql db using SSIS. I am able to connect to the postgresql db from SSIS just fine.

Upvotes: 1

Views: 2042

Answers (2)

Hasangi
Hasangi

Reputation: 320

Use Execute SQL Task and create an ADO.NET Connection instead of ODBC or OLE DB and create a connection for your PostgreSQL.

enter image description here

Upvotes: 1

ɐlǝx
ɐlǝx

Reputation: 1394

Just adding Toolbox Execute SQL Task, then edit Toolbox and in tab General fill in the following fields:

  • Connection Type: OLE DB

  • Connection: choose your postgresql connection

  • SQLStatement: insert your query

    That's all. I hope this help you.

Upvotes: 2

Related Questions