October 23, 2008 at 10:44 am
Here is the error I am having:
[DNC_Full_File [1]] Error: Data conversion failed. The data conversion for column "Column 6" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
What I have tried:
Removing Nulls in the file
October 23, 2008 at 2:14 pm
Why don't you change the error output of the data conversion task to send the error to a file so you can see the data that is causing the error?
My guess is the error is that you do not have the conversion set to a large enough string so it is failing because of truncation. You can fix it by changing the data conversion to use a unicode string instead of a regular string and making it longer (from 25 to 30).
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
October 28, 2008 at 6:34 am
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply