Hi all,
I have a flat file with the following format, In the beginning 1 Header Record, In the End 1 Trailer Record and in the middle Detail Records.

For example See Below
H……
D……………
D……………
D……………
D……………
T……

Now the problem is how I can load into the table? I know I have to use SQL loader and I can load one flat file without Header & Trailer But what if I have every thing in one file? What techniques I will use perform this task.

Thanks in advance
Aph.