Wednesday, 3 November 2010

SSIS & Postgres using PGNP provider

We've been using SSIS for a while now to connect to Postgres for archiving our production database. Natively SSIS can't connect to Postgres, so we've been using a provider called PGNP (http://www.pgoledb.com/), it seemed a but buggy to begin with, but their support is excellent and it has come a long way in the last year!

Using SSIS proved to be much quicker and easier to maintain (after the initial learning curve) for ETL tasks and soon we'll be re-designing our data warehouse. Thanks to PGNP.

No comments:

Post a Comment