question

dhandapani avatar image
dhandapani asked

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?

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?

migration
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

What error?

Have you deployed all the needed drivers for PostgreSQL to the SQL server so it can establish connection? Firewall ports opened etc?

0 Likes 0 ·

1 Answer

·
dhandapani avatar image
dhandapani answered

Yes , I have installed the driver in all region.(the same driver is working in local system)

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

What error(s) are produced?

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.