Header row is missing in ftp enterprise stage

[premupdate]

Hello folks,

Job Design:

Sequentialfile-->copy-->ftpenterprise stage


I want to transfer the file to another server through FTP stage.

In file it contains 50 data records and one header record has column name.

The target server receives file which has only data records and not header record.

Sequential file Options:

Enabled first line is column name to true.

Kindly help me to resolve this issue.

[chulett]

Sequential file Options: Enabled first line is column name to true.

That option causes the headers to be skipped, turn it off so the header record just flows through as data.

[ray.wurlod]

Change First Line is Column Names property value to False. Make sure that your metadata allow the header line to be read (even if you have to read each entire line as a single string), rather than be rejected/dropped.

[premupdate]

Thanks for your help. It is working fine.