Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SSIS data flow destination
15 views
Skip to first unread message
Mars
Nov 6, 2009, 4:05:01 PM11/6/09
to
Hi
I'm trying to update a postgreSQL table from sql server 2005 table.How do I
write to Postgresql since odbc destination is not an option in ssis?
I'm trying to update a postgreSQL table from sql server 2005 table.How do I
write to Postgresql since odbc destination is not an option in ssis?
Thanks in advance
![Charles Wang [MSFT]'s profile photo](http://lh3.googleusercontent.com/a-/ALV-UjWygTqbdvoUoFyg4IjeNC7KH4zZMp8slMf48KEvFEiZV4tDQA=s40-c)
Charles Wang [MSFT]
Nov 9, 2009, 8:32:51 AM11/9/09
to
You need to install an OLE DB Provider for Postgresql database on your
computer first. After that you can use the OLE DB Destination to connect to
your Postgresql database with the provider.
computer first. After that you can use the OLE DB Destination to connect to
your Postgresql database with the provider.
You can find some from internet like:
http://www.postgresql.org/download/products/2
http://www.pgoledb.com/
Best regards,
Charles Wang
0 new messages