DSXchange

There is no way in DS to store and import table definition for Sequential file.
Want to create an Utility in Visual Basic , so that it can create the metadata structure of Source/Target file from Source to Target mapping document and directly import that metadata definition in DataStage designer.

1. What will be the metadata Structure i need to create through my utility tool ?

2. How to import it directly in DataStage designer without any manual intervention

Let's just start with this:

das_nirmalya wrote:There is no way in DS to store and import table definition for Sequential file.

Not true, of course you can. Wouldn't be much of an ETL tool if it couldn't do that. Unless you mean something other than the rather generic statement that it seems you are making?

See my answer to your other post with this question.