Problem with boolean fields ...

[takrl]

Hi,

I'm trying to transfer a table content from SQL Server 2005 to postgres 8.2 using SSIS. The source table has some fields defined as "bit". The destination table has the same field defined as boolean, they always receive "FALSE" as value, regardless of the setting in the source table.
I exchanged the PGOLEDB-Destination for a SQL Server destination and it worked without problems.
Any ideas anyone?

Cheers
Michael Ehrt

[Moderator]

Hi, looks like the bit field conversion broke in one of the recent builds and the defect slipped throu our tests. We are working on the fix. We'll send you link to the fixed provider module shortly.

Thank you!

[Moderator]

We have fixed the defect and uploaded the fixed version:
http://www.pgoledb.com/downloads/PGNP32-1.2.8.1145.exe
http://www.pgoledb.com/downloads/PGNP64-1.2.8.1145.exe

[takrl]

Hi,
works fine, thanks for the fix!
Cheers
Michael