SSIS Configuration connect PostgreSQL Database

Professional noun Explanation:

1, Odbc:open Database connectivity open Databases interconnection.

Simply say he is an intermediary, you develop the software to connect him, he connected to the data source (that is, the database). This database is access, or SQL Server, or Oracle, as long as it is set up in ODBC. This allows ODBC to isolate the implementation details of the database, freeing the software developer from falling into the implementation details of the specific database.

In the convenience of software development, but also facilitates the upgrading of software systems.

2. Dsn:data source Name, data source names

1, because the SSIS connection on the database requires a middle tier, that is, ODBC, is: http://www.postgresql.org/ftp/odbc/versions/msi/

I downloaded the last two, which is the following:

Psqlodbc_10_03_0000-x86.zip Psqlodbc_10_03_0000-x86.zip

Psqlodbc_10_03_0000-x64.zip Psqlodbc_10_03_0000-x64.zip

2, download the end of the installation of your two ( Note: Whether your Windows system is 32-bit or 64-bit two need to install )

After installation, the drivers interface of the DSN can see the corresponding ODBC information, the following 2 is a 32-bit one is 64-bit (open the interface directive: ODBCAD32), only after the user DSN is set up in SSIS to select the corresponding server.

3, click to the following interface, no configuration before the interface may be empty, the configuration process is as follows 0 to 6, 1 can be customized 2 of their own need to connect the db,3 serverip,4 is the login name and login password, 5 is the port number of the connection, the information needs to be provided by the manufacturer, 6 default this ghost is on line 7 configuration can be To test SSIS connection db by clicking "Test"

Add 64-bit user DSN C:\Windows\System32\odbcad32.exe

Add 32-bit user DSN C:\Windows\SysWOW64\odbcad32.exe

4, to here the DSN configuration is also over, you can start the SSIS development, the following interface is a new "connection management", this "connection management" in the new "SSIS Packages" in the "Data Flow" Design of "ODBC Source" inside the " Connection Manager "will use (numeric order is the order of actual operation) 2: Because we configure the ODBC data connection interface, so choose this, 4: Here we need to develop a data source, through the drop-down box to select our third step 1 The information that is configured here (this is not the same reason because I have a new definition of a postgresql_10.90.20.119, the actual operation of the time is the same) 5: Enter your own login PostgreSQL username and password, set up after the link can also test the situation.

5, the last step after the "connection management" is set to complete, the process of creating a new package is as follows:

6, the following process is to create an ODBC data source ( it is necessary to take the data from this DB ), 2: Is the 4th step to establish the connection, now displays the format is: Data source name. Login to the database user name 3: Use the instructions, if you need to filter the field can also use 4 To filter fields

7, the target db (is to plug the data into this DB) 1: This item if it is not possible to create a new 2: the corresponding table

8, if the 6th and 7th step of the table field name is the same, then will automatically match, such as, if not the same as the development of the line.

SSIS Configuration connect PostgreSQL Database