10 row/second insert in ssis - Mailing list pgsql-odbc

From Bill Kuhn
Subject 10 row/second insert in ssis
Date
Msg-id CAM5fj=bzg-TfO6n-JKh66uAC+NZv8dZLxQXgbuyTVF35JEgM2g@mail.gmail.com
Whole thread Raw
Responses Re: 10 row/second insert in ssis  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-odbc
Greetings.

Is there anything special to configure to use the 32 bit odbc driver?

I'm attempting to use the odbc driver to transfer data from microsoft sql server to postgresql and I'm seeing dismal insert performance.  It is as if each insert is being performed individually.

The rows I'm inserting only have one integer column.

Is there anything special that needs to be done to configure the driver to improve performance?

Many thanks.

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: Some bug fixes and improvements
Next
From: Adrian Klaver
Date:
Subject: Re: 10 row/second insert in ssis