1.2k questions

1.4k answers

361 comments

339 users

Categories

Sidebar
0 votes
356 views
by chris-m-3214 (320 points)
Is there a way to set the Fixed Width Record Length setting programmatically?  I'd like to have one channel that processeses all my fixed width files based on conditions so I need to set the fixed width programmatically for each particular file spec.

1 Answer

0 votes
We need a little more information but my first thought would be to use a system variable lookup table.

Using the first column to describe the name of what different values you want and then the following columns to define the different lengths.
by michael-h-5027 (14.8k points)
by chris-m-3214 (320 points)
I have fixed-width files of varying lengths so I am trying to find a way to set the fixed width record length value for the source at run time.  I can definitely set up a system variable lookup table.  How would I refer to that in the record length setting for the fixed width source?
...