August 8, 2008 at 1:44 pm
I created an SSIS package: data going from Table A --> data conversion --> Excel file as destination.
I am getting this error:
[Data Conversion 1 [55]] Error: Data conversion failed while converting column "SummaryLine" (29) to column "SummaryLine" (79). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
The data type on the source table for column SummaryLine is varchar(2000)and on the destination it was Unicode String [DT_WSTR] 255. I changed the length to 2000 but still I keep getting the same error.
please advise.
August 8, 2008 at 2:25 pm
You are not getting a conversion error saying it can't convert the non-unicode string to a unicode string?
I'd stick a data conversion transform in between and convert it from non-unicode (varchar) to unicode in the data conversion.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 8, 2008 at 4:01 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply