I have tab delimited csv's with UCS-2 LE encoding that I need to import to SQL using SSIS. I intend to bring multiple files in using SSIS and parse to various tables and columns either within SSIS (preferred) or in SQL. I am using 65001 (UTF-8) code page on the flat file connection, "Unicode" is checked because we have some special characters in the file.
In the preview page, I can see what appears to be my tabs in the source file. However, when I use the flat file connection as a source, the tabs become spaces in the output, whether to a table, or to another flat file.
Is there a way to import UCS-2LE csv's as ragged right and retain the tabs in the output column?