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

Hello,

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?
psimonis
 
Posts: 5
Joined: Wed Jun 05, 2013 7:25 am

Ray Ban Sunglasses On Sale

Postby dwfcllmudn9R » Fri Aug 01, 2014 2:11 am

how to advertise eyewear associated with electric outlet in 5 solutions (2)how to distribute sun glasses that retail outlet in 5 ideas (2) cheap oakley dispatch sunglasses ray ban glasses, ,
Although fashion changes with the course of time and contemporary lifestyles, but time and again it tends to revive itself. Sunglasses that are the hottest choice of people today were popular in earlier times as well. With few modifications, these have come up as the latest styles and designs for fashionable people. cheap discount oakley sunglasses ray ban sunglasses, ,
How many times you would have faced the situation where your eyes got troubled by the glare. Many a times! Isn鈥檛 it? Glare is difficulty seeing anything in the presence of extreme bright light, which causes strain on the eyes but the polarized sunglasses selectively eliminate the reflection of light coming from the water surface or any other reflecting object and enable to see things clearly. The skiers, fishermen and boaters are the people who face glare the most, as most of these activities are performed in bright daylight, and do you know that too much of exposure to the glare may result in a Cataracts, which leads to running water from the eyes and later turns white and can obstruct light by causing near-sightedness (myopia). There is an easy way to prevent your eyes from Cataracts and it is to wear a pair of Polarized oakley gascan sunglasses mk sunglasses, ,
These sunglasses are leading eyewear design that is the manifestation of liberty. A Prada sunglass shields your eye from the ultra violet rays from the sun keeping you safe from the scorching rays as well. Every single pair of Prada sunglasses are made of latest material and technology to bring forth a product of complete craftsmanship. Each design in the collection has been artistically designed to the utmost level of perfection.
.
dwfcllmudn9R
 
Posts: 23
Joined: Fri Aug 01, 2014 2:00 am


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

Who is online

Users browsing this forum: No registered users and 2 guests

cron