Copy SQL Server Data to PostgreSQL vice versa using SSIS( SQL Server Integration services) using Free tool Devart Express edition

We can connect PostgresSQL using the Devart Free SQL Edition using SSIS tools(Visual Studio 2019) tools. 

Open Visual Studio and go to Extensions --> Manage Extensions

Its a Free tool to connect using PostgreSQL with basic limited features. But it support creating destination table if not exists.

It will redirect ot their link

dotConnect ADO.NET Data Provider for PostgreSQL Express - Visual Studio Marketplace

Download dotConnect for PostgreSQL (devart.com)

Download the Free version of dotConnect for PostgrSQL 7.20 Express

After installation, you can restart visual studio and open SSIS projects.

Select new connection. Select the dotConnect for PostgreSQL

Provide all the details and select allow saving password so that the password can be used while executing the package.

Save the connection. use the Ado.net Destination.

Map the columns and save. We can use click if we need to create a destination table.

run the SSIS Package. Package running fine.