Hi All,

Does any one knows how to create flow for that moves flat file data (.txt) to sql server table? I am getting error when directly I m trying to create flow using Flat file local adaptor about " COBOL FD " ....and its warning that no metadata selected. Please provide COBOL FD "

This message has been edited. Last edited by: Tamra,

mayur,

Welcome to Focal Point! Happy 2017 !

Here are a few link related to Cobol FD synonym creation.

How to use a flat file as a source in DataMigrator

How to convert a COBOL Copybook to a FOCUS Master File

How to create a synonym for a fixed length flat file

Here is the Data Migrator user's guide 7.7.05 which may also help with answering your question.

If you need further assistance please let us know.

Thank your for participating in the Focal Point Forum,

Tamra Colangelo
Focal Point Moderator
Information Builders

What do you mean by flat file data?

If it is indeed a fixed file format then you do need to describe the file either from a COBOL FD or in the synonym editor.

However if there is a delimiter (such as a comma or tab character) between the values, you can use the Delimited Flat File adapter which can automatically generate a synonym.