Loading data from a flat file
You can use the same File Format object created in the previous recipe to load data from a flat file. In the following section, we will take a closer look at file format options relevant to loading data from the files.
How to do it…
Create a new job and a new dataflow object in it.
Create a new text file,
Friends_30052015.txt
, with the following lines inside it:NAME|DOB|HEIGHT|HOBBY JANE|12.05.1985|176|HIKING JOHN|07-08-1982|182|FOOTBALL STEVE|01.09.1976|152|SLEEPING|10 DAVE|27.12.1983|AB5
Go to Local Object Library and create a new file format by right-clicking on Flat Files and choosing New.
Populate the File Format options as shown in the following screenshot:
Delimiters | Column is set to
|
in this case as our file has the pipe as a delimiter.NULL Indicator was set to
NULL
, which means that onlyNULL
values in the incoming file are interpreted asNULL
when read by Data Services. The other "empty" values will be interpreted as empty strings.Date format is set...