Working with fixed width Files

Following are the steps that you will have to perform to work with fixed width Files:

1. In the Designer, go to Tools | Target Designer to open the Target Designer.
2. Go to Target | Import from File....
3. Browse the files you wish to use as source files.
4. The Flat file import wizard will come up.
5. Select the file type -- fixed width. Click on Next.

1. Set the width of each column as required by adding a line break. Click on Next.
2. Specify the column names, data type, and precision in the data view option. Click on Next.
3. Click on Finish to get the target imported in the Target Designer.

Just as in the case of working with sources, we move on to the create option in target.