DSXchange

Does Anyone know how to automatically load the table definition into the job design ??

I have many jobs which base on the sequential files. The changes of this files are very often. I would like to find a way how to automate the process of loading the structure of the changed files into the DS and then populate it to the design of the jobs. I know manual way how to do it but it is not a solution.

There's no automatic method within the tool. There are reverse-engineered "hack" utilities that could be written, but the only method I use in this circumstance is a staging database that can contain file layout information within a table and dynamically parse it.

You could do the same, read the parsing information from a table and then manually parse the file and re-arrange it into the known and fixed definitions that a DS job requires.