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?