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

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

You can add the connection directly in the Task component

SSIS Postgresql ExecuteSql Task UI

Create your multiple SQL statements

Execute Postgresql DDL Commands using PostgreSql ExecuteSql Task

SSIS PostgreSQL ExecuteSql Task accepts variables with the SQL statements

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

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 […]