I have not yet found a satisfactory answer for why this is so. The driver will fail to retrieve larger datasets if you do not check this box. After you have supplied values for these fields, click the Datasource button and make sure the Use Declare/Fetch box is checked.The Administrator will present a screen on which you must supply a database name, server name, user name and password.Select the version you need and click Finish. Scroll to the bottom and you will see two options for PostreSQL ANSI and Unicode. The ODBC Administrator will present a list of drivers.Launch the ODBC Administrator Utility and choose the type of data source you need File, System or User and click Add.msi file for Windows from this location: Here are the basic steps to get the driver working: Installation of both drivers (32-bit & 64-bit) is identical. I will recap the steps directly from this post: There is a great blog post on Connecting to a PostgreSQL Instance Using SQL Server Integration Services which you’ll want to read.
