Mapping a column to DT_BOOL

Jan 7, 2010 at 8:35 PM
Edited Jan 7, 2010 at 8:38 PM

I have been trying to import a delimited file yyyy,zzzz,0  where 0 is the third value and is mapped to a column dt_bool. I keep getting an error
Format error - failed to convert source data to output column type.
It looks like it can't translate a value of 0 to boolean.

Any ideas, what i'm doing wrong.

By the way, it i change the value and instead of "zero" use true/false it works, but all my files have a flag of 0,1 for bit columns.

Jan 18, 2010 at 9:16 PM


Apologies for delay in getting back to you. You were doing nothing wrong, the component was simply not set up to handle bit data for booleans - this has now been fixed in the sourcecode.

I haven't done a full release because I'd like to address a few other things first, but you can use/test the updated DLLs here: DFS 2005 and DFS 2008