Skip to Content
0
Feb 09, 2011 at 03:40 PM

Getting correct field length when creating formats for delimited flat files

131 Views

Using Data Services 3.2 to pull in tsv and Excel source files.

When creating a new format for each file, DS tries to intelligently set the field size for each column. However, it seems to sample only a portion of the file. The end result is that it often determines too short a length for a field.

Is there a way to force it to scan an entire file before it sets the field length? Or alternatively, how to get it to at least throw an error instead of silently truncating my data?