In these days most of the databases are migrated to Could databases such as Azure SQL Database. In here I would share my experience that PostgreSQL as source for SSIS.
There are many connectors available for PostgreSQL, however most of them are not free. I found the free connector with latest update in the following link:
You can download based on the source architecture
The easiest way is creating a ODBC connection for PostgreSQL and connect via ODBC source in SSIS.
The following screenshots illustrates the ways to create a ODBC connection.
Once you establish your ODBC connection use ODBC source to connect.
Cheers!
Uma
Uma
How to load csv file into postgresql using ssis
ReplyDeleteThanks for this very valuable info, you saved my life,SSIS Postgresql Read I wasted more than 1 day of work trying to solve this.:)
ReplyDeleteThank you for putting up a descriptive post on a very useful aspect of SQL. This actually helped me a lot to understand this topic.
ReplyDeleteSSIS PostgreSql Write
This is an exclusive post about PostgreSQL and the use of foreign data wrapper actually overcomes and helps people solve the most complex problems and errors.
ReplyDeletessis postgresql read
online slot
ReplyDeletepermainan slot
play slot
togel slot
agen slot dan togel