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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics