![]() ![]() ![]() The suggested solution on TechNet is to change a registry key to increase the number of rows the Excel data source will sample to determine the length of a text column. The obvious problem is that if any row after 9th row is longer than 255 characters, the import will break with the error message: “Text was truncated or one or more characters had no match in the target code page.” If it does not find any column longer than 255 characters, it will set the columns type as DT_WSTR with a length of 255, otherwise it will use DT_NTEXT (see Excel Source on TechNet for more details). It does so by sampling the 9 first rows in the spreadsheet and measuring their length. When using SQL Server Integration Service (SSIS) Excel data source to import text from a column in a spreadsheet, the data source will automatically try to determine the maximum length of text in the text column. SSIS: Solution for Excel data source text truncation of column with more than 255 characters ![]()
0 Comments
Leave a Reply. |