SSIS Data Load Freezes

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
mnowill
Posts: 4
Joined: Wed 01 Oct 2008 16:59

SSIS Data Load Freezes

Post by mnowill » Thu 04 Dec 2008 17:00

I have installed the new version of the Postgres Driver and run into an issue. I am pulling from a Unicode table (just a select *) and the process begins without any issues but doesn't complete...it just hangs at a certain point. I have attempted to run it multiple times and always hangs at the same point. I have tried changing the Unicode setting for the driver and that just changes what record the read fails at. I have also pointed the driver to others tables and had mixed results...some work without issue while other have the exact same issue.

Any ideas?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 05 Dec 2008 12:12

Please specify the version of SSIS you are using. Can you send me a script to create database objects and fill them with data?

mnowill
Posts: 4
Joined: Wed 01 Oct 2008 16:59

Post by mnowill » Fri 05 Dec 2008 14:52

SQL 2005 Enterprise 64-Bit

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 09 Dec 2008 15:29

We cannot reproduce the issue. Could you please send me (alexsh*devart*com) a script to create database objects and fill them with data? What is the version of dotConnect for PostgreSQL you are using?

Post Reply