When you add Text Data Provider to a project, Sybase ETL opens a component window and prompts you for the source file. Identify the source file, then use the component window to identify properties about the source data.
To use the Text Data Provider
Add the component to the project. The component window and the Open File dialog box open.
Select a file or close the window to enter a name in the Text Source field. After select the file, you are prompted to select file description properties.
While reading the file, Sybase ETL tries to make best assumptions about the structure of the file, but any value can be modified.
The following message appears “Do
you want to generate the column definition?”.
Click Yes if you want to create columns based on the current settings.
Click No to create a single column.
