Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS 2008 possible truncation/loss of data??? Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 9:59 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 18, 2013 1:23 PM
Points: 90, Visits: 286
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.
Post #1346801
Posted Friday, August 17, 2012 10:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 18, 2013 1:23 PM
Points: 90, Visits: 286
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
Post #1346805
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse