将 SSIS 连接到 PostgreSQL 的问题(通过 OLEDB) [英] Issue in Connecting SSIS to PostgreSQL (via OLEDB)

问题描述

我正在处理一个项目，我必须在其中创建用于数据迁移的 SSIS 包.我使用 PostgreSQL 进行数据库连接.最初，我使用 ODBC 驱动程序将 SSIS 项目连接到 PostgreSQL，后来，我发现 ODBC 不支持在发生任何故障时回滚以前的事务(插入、删除、更新等)的事务.现在，我需要使用 OLEDB 进行数据库连接.

I'm working on a Project, where I have to create SSIS Package for the Data Migration. I'm using PostgreSQL for the database connectivity. Initially, I was using ODBC driver to connect SSIS Project to PostgreSQL, later on, I found that ODBC doesn't support transactions for rolling back previous transactions(insertion, deletion, updating etc) if any failure occurs. Now, I was required to use OLEDB for database connectivity.

在谷歌上，我了解到两个 PostgreSQL 的 OLEDB 提供程序，它们是:

On Googling, I came to know about two OLEDB providers for PostgreSQL, which are :

http://pgfoundry.org/projects/oledb/ - 开源http://www.pgoledb.com/index.php/component/filecab... - 商业

http://pgfoundry.org/projects/oledb/ - OPEN SOURCE http://www.pgoledb.com/index.php/component/filecab... - COMMERCIAL

第一个，它是开源的，根本不起作用.它的最后一次更新是在 2006 年，所以我认为他们不打算更新它以使其与 SSIS 配合使用.

First One, which is Open Source, is not at all working. Its Last Update was in 2006, So I don't think they are planning to update it to make it work with SSIS.

第二个，这是商业的，正在工作.我尝试了试用版，我必须说这个提供者很棒.但是，他们对完整版收费过高.

Second One, which is commercial, is working. I tried the Trial Version and I must say this provider is awesome. But, they are charging too much for the full version.

请提供实现此目的的任何解决方法(将 SSIS 连接到 PostgreSQL 并完全支持事务.)

Please provide any workaround for achieving this(Connecting SSIS to PostgreSQL with full Support of Transactions.)

推荐答案

更新

我找到了解决方案.我们可以在创建新的 Ado.Net 连接时从下拉列表中的 .Net Provider 选项下选择 ODBC 提供程序.

I found the solution. We can select ODBC provider under the option of .Net Provider from the dropdown at the time of creating new Ado.Net connection.

我想知道这个 ODBC 驱动程序是如何支持事务的，尽管到处都提到 ODBC 不支持事务.至少，我让它工作了.干杯！！

I wonder how this ODBC driver is supporting transactions even though everywhere it is mentioned that ODBC doesn’t support transactions. Atleast, I got it working. Cheers!!

这篇关于将 SSIS 连接到 PostgreSQL 的问题(通过 OLEDB)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！