Table of Contents

Search

  1. Preface
  2. Introduction
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Example 1: Read Flat File

Example 1: Read Flat File

Follow the steps below to read the flat file data and load the data into a RowSet.
  1. From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Read Flat File task to the Project Outline.
  2. On the Basic tab of the Read Flat File task, specify values for the following attributes:
    Input File
    The file path and file name of a single file from which to read the data.
    Output RowSet Variable
    The name of a variable which will contain the data read from the specified input file(s).
  3. On the Advanced tab of the Read Flat File task, specify the Record Delimiter type:
    Start Row
    Specify the row to start reading data from the file(s).
    Skip Empty Rows
    Specify whether or not to skip empty rows.
    Record Delimiter
    The character or sequence of characters that separate each record.
  4. When complete, click the
    Save
    button.

0 COMMENTS

We’d like to hear from you!