SSIS2012 Connecting the PostgreSQL database

Source: Internet
Author: User
Tags driver manager odbc odbc connection postgresql ssis

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.