SSIS crashing on Export to Flat File due to special characters
I'm trying to export a list from my database to a flat file through SSIS. I am able to export to Excel without a problem, however it consistently crashes when exporting the same information to flat file. The reason it provides is below:
[Flat File Destination [545]] Error: Data conversion failed. The data conversion for column "Title" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Flat File Destination [545]] Error: Cannot copy or convert flat file data for column "Title".
The actual row that I am trying to insert includes this under 'Title' is below. It is that last character that's giving me a problem.
Unified Wireless L2+ Gigabit Switch
How would I go about having SSIS ignore these characters? I have it set to ignore the row whenever there is a problem, but for whatever reason, it doesn't in this case.
June 27th, 2012 4:00pm
Hi,
Try setting the unicode checkbox on file connection and use dt_wstr datatype for all string content specifically for Title.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2012 4:22pm