SSIS 2008 possible truncation/loss of data???

• MissyDaisy

  Ten Centuries

  Points: 1164

  More actions

  August 17, 2012 at 9:59 pm

  #280366

  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.

• MissyDaisy

  Ten Centuries

  Points: 1164

  More actions

  August 17, 2012 at 10:17 pm

  #1527297

  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