SSIS Json Source (File, REST API, OData) - Extract, Parse, Output

SSIS PostgreSQL Execute SQL Task

PostgreSQL Execute SQL Task can can be used to execute DDL and DML statements for PostgreSQL without needing any extra driver. You can Issue various sql commands such as SELECT, INSERT< DROP, COPY, CREATE etc.

Features

  • Allows to execute queries against PostgreSQL without ODBC driver
  • Load query at runtime from variable, file or Direct value
  • 100% Managed code means its 32bit and 64bit compatible
  • You can issue COPY, UNLOAD commands very easily
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see articles related to PostgreSql

 

SSIS Video Tutorial
Download Help File Buy
View All Tasks
ScreenshotsSystem Requirements

In Visual Studio, drag and drop the ZS PostgreSQL ExecuteSql Task

In Visual Studio, drag and drop the ZS PostgreSQL ExecuteSql Task in the design surface

In Visual Studio, drag and drop the ZS PostgreSQL ExecuteSql Task in the design surface

You can add the connection directly in the Task component

SSIS Postgresql ExecuteSql Task UI

SSIS Postgresql ExecuteSql Task UI

Create your multiple SQL statements

Execute Postgresql DDL Commands using PostgreSql ExecuteSql Task

Execute Postgresql DDL Commands using PostgreSql ExecuteSql Task

SSIS PostgreSQL ExecuteSql Task accepts variables with the SQL statements

Execute PostgreSQL command from variable

Execute PostgreSQL command from variable

Articles / Tutorials

Click here to see all articles for [SSIS PostgreSQL ExecuteSQL Task] category


Execute SQL query against PostgreSQL in SSIS

Execute SQL query against PostgreSQL in SSIS

Introduction ZappySys provides high-performance drag and drop connectors for PostgreSQL Integration. In this post you will see how to Execute SQL query against PostgreSQL in SSIS, in various SQL commands such as SELECT, INSERT, DROP, COPY, CREATE, etc using PostgreSQL Execute SQL Task can be used to execute DDL and DML statements for PostgreSQL without needing any […]

Click here to learn more about System Requirements
Download View All Tasks Like This