ADO .NET boolean issues

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

ADO .NET boolean issues

Postby psimonis » Fri Aug 02, 2013 12:09 am


When trying to write data to a boolean column using an ADO .NET destination with the PGNP driver, errors occur.
(Provider=PGNP.1;Data Source=localhost;Persist Security Info=True;Password=**********;User ID=********;Initial Catalog=*********;Extended Properties="COMMAND_TIMEOUT=0;SQLSERVER=2008;SSL=allow;BULK_INSERT=1000000;")

The error occurring is:
Error: 0xC020844B at Institutions Organisaties, ADO NET Destination [948]: An exception has occurred during data insertion, the message returned from the provider is:
ERROR: column "actief" is of type boolean but expression is of type integer LINE 1: ...("dtype","actief","schema","naam","id") VALUES($1,$2,$3,$4,$...
HINT: You will need to rewrite or cast the expression.

This column is added manually in a Derived Column block like this: (DT_BOOL)TRUE.
An OLEDB destination to the same database and table does not give this error.
Perhaps someone can look into this?
Posts: 5
Joined: Wed Jun 05, 2013 7:25 am

Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest