First of all, I have attached the source file (Excel file), the destination file (CREATE TABLE) and other information.
Trouble converting a column in Excel that is Unicode Text Stream to SQL Text Stream, sounds simple.
In the Data Flow of SSIS I have the Source (Excel Connection Manager), the Data Conversion and Destination (OLEDB). In Data Conversion the input column is "Comment" the Output Alias is "Copy of Comment" and Data Type is "text stream [DT-TEXT]".
When I execute the Data Flow I receive the attached errors, truncation. If I Configure Error Output to "ignore" mostly empty rows are inserted into the table.
How do I correct this?
Please let me know if you need anything else.