SSIS 2008 possible truncation/loss of data???

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » SSIS 2008 possible truncation/loss of data???...

SSIS 2008 possible truncation/loss of data???

Rate Topic

Display Mode

Topic Options

Author

Message

MissyDaisy

Posted Friday, August 17, 2012 9:59 PM

SSC 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

MissyDaisy

Posted Friday, August 17, 2012 10:17 PM

SSC 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 »

Permissions