Re: [GENERAL] PostgreSQL and SSIS

2011-05-23 Thread John R Pierce
On 05/23/11 1:38 PM, Bailey, Rick wrote: I have an Microsoft SQL Server IS job that has been running in production for several years. It pulls data from a PostgreSQL 8.4.2 database on Linux into an SQL Server 2005 installation on Windows Server 2003 (all 32-bit). I am re-writing this in a

Re: [GENERAL] PostgreSQL and SSIS

2011-05-23 Thread Dann Corbit
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Craig Ringer > Sent: Monday, May 23, 2011 11:00 PM > To: Bailey, Rick > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PostgreSQL and

Re: [GENERAL] PostgreSQL and SSIS

2011-05-23 Thread Craig Ringer
On 24/05/11 04:38, Bailey, Rick wrote: > On the Windows Server 2008R2 machine, I installed 64 bit Postgres ODBC > drivers and found that I could not see them when creating an ADO.net > connection manager in BIDS. "BIDS" appears to be the Microsoft "Business Intelligence Development Studio," an ad