My column is of type bit in a sql server 2008 database.
My sql query has a case statement which reads:
WHEN 1 then 'YES'
end as myFlag
I have to dump that table to a .csv file from a .dtsx package. The file connections has myFlag as unicode string (DT_WSTR) output column width 100.
To my surprise, that error with a conversion issue stating
The column status returned was: "The value could not be converted because of a potential loss of data.".
I am at a loss. The case statement already maps the bit value to Yes or No. Yes or no cannot be converted to unicode string (DT_WSTR) output column width 100 ??? because of possible truncation/loss of data???
Please throw some light. Thank you.