Hi @pandiyanrajendran rajendran ,
Please try to use other driver for PostgreSQL.
Hope the following links will be helpful:
- Software Catalogue - Drivers and interfaces
- Get the PostgreSQL ODBC driver
- Export data from Postgres to SQL Server using SSIS
In this example, the database used to import data is the 'Postgres' database which is installed by default. We will use this database to export data from the students table in Postgres to SQL Server with SQL Server Integration Services.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.