Working with delimited files

Following are the steps that you will have to perform to work with delimited 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 import as source files.
4. The flat file import wizard will come up.
5. Select the file type -- Delimited. Also, select the appropriate option to import the data from second row and import filed names from the first line as we did in case of importing the source. Click on Next.
6. Select the type of delimiter used in the file. Also, check the quotes option -- No Quotes, Single Quotes, and Double Quotes -- to work with the quotes in the text values. Click on Next.
7. Verify the column names, data type, and precision in the data view option. Click on Next.
8. Click on Finish to get the target file imported in the Target Designer.

We now move on to fixed width files.