Scenario: Company business Database bit PostgreSQL database, need to use ETL tool (SSIS2012) to extract data into Data Warehouse 1. SSIS2012 Connect PostgreSQL database Two ways:. NET Provider for OLE DB and ODBC, the first colleague is to spend money to buy from the foreigner side of the plugin (if a friend has a free connection adapter, to share!) ) as the first type. We introduce the second approach here.
2. Download the ODBC Connection driver for PostgreSQL. http://www.postgresql.org/ftp/odbc/versions/msi/I am using PostgreSQL 09 02, my server is 64 bit, but note that here 32 and 64 bits must all download down, later useful. 3. Install the ODBC connection driver. 4. Configure Drive Management
5. Then use SSIS to connect and discover the following issues.
Error here, "error [IM014] [MICROSOFT][ODBC Driver Manager] in the specified DSN, driver and should be" after analysis, I found that is SSIS2012 only support 32-bit connection, the default 64-bit connection error. Then reinstall the 32-bit and 64-bit ODBC connections for PostgreSQL. 6. A 32 ODBC PostgreSQL connection must be created on a 64-bit server. Re-establish an ODBC connection in the operating system run Bar "C:\Windows\SysWOW64\odbcad32.exe"
7. Re-use the SSIS connection attempt to successfully
SSIS2012 Connecting the PostgreSQL database