Here is the situation, please let me know if you have any tips:
..TXT files in a share at \\foo
SPROCS run daily parses of many things, including data on that share. The
other day, we encountered rows in the TXT files which looked like:
column1Row1data,column2Row1data
column1Row2data,column2Row2data
...etc..
However, column2 was about 6000 bytes of unicode. We are bulk inserting
into a table specifying nvarchar(4000). When it encounters high unicode
rows, it throws a truncation error (16).
We really need information contained in the first 200 bytes of the string in
column2. However, the errors are causing the calling SPROC to abort.
Please let me know if you have any suggestions on workarounds for this
situation. Ideally, we would only Bulk Insert a sub-section of column2 if
possible.
Thanks!
/Ty