August 17, 2012 at 9:59 pm
My column is of type bit in a sql server 2008 database.
My sql query has a case statement which reads:
case myFlag
WHEN 1 then 'YES'
else 'NO'
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.
August 17, 2012 at 10:17 pm
I found the issue. The case statement result is of type DT_STR. Putting that result into a DT_WSTR could cause data loss thus the error.
I changed the data type to be string DT_STR in the file connection manager. Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply