I am tring to move data from postgres to sqlserver, using psqlodbc driver i can able to move data. but when i am trying to deploy a ssis package its throwing error. anyone can help to resolve this?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Have you deployed all the needed drivers for PostgreSQL to the SQL server so it can establish connection? Firewall ports opened etc?
Answer by dhandapani · Feb 07, 2020 at 12:17 PM
Yes , I have installed the driver in all region.(the same driver is working in local system)
What error(s) are produced?
Answers Answers and Comments
17 People are following this question.
What is the best way to convert a schema script from SQL Server to Oracle?
SQL Server with peer-to-peer replication migration from on-prem to AWS EC2 instances
Merge replication Plan from SQL 2000 to SQL 2012
what is the easiest way of getting database in sync
how to identify sql server deprecated features of 2000 and 2005 in 2008 server