A data provider sends my client a fixed width file - 70+ fields and over 600
Right now the client uses a VB6 program that parses the data and loads it to
SQL. I don't have the source code (neither does the client), and the
documentation of field widths in this file is clearly wrong. Worse, the
layout of the file is supposed to be changing in the near future.
I'd like to use DTS and be able to experiment with different settings, but
modifying the settings for 70+ fields isn't just tedious, it's really error
Is there an easier way to do this besides dragging the little arrows back &
Does the DTS programming object offer some functionality in this regard.
I've spend a little time scrolling through some of the methods and
properties but haven't found any references to this issue.