DTS with multiple row types

[mingus]

I have a file that looks like:

#HDR|AAAA||
0|A|B|2
1|A|B|3
#FOOTER|AAAA||5

I have table of five fields. I need to put the hdr info into that table with the four fields on each line that is not a header or footer. Is that possible with DTS? Or must all the lines in the represent the same data?

thanks for any help

 

[tlbroadbent]

I believe you could use DTS but need a little more info.
[ol][li]Does the sample represent a typical set of data? That is, header, two data rows and footer or is the number of data rows variable?
[li]What would the resulting table would look like? From your decsription, I assume the following.
[tt]
Col1 Col2 Col3 Col4 Col5
AAAA 0 A B 2
AAAA 1 A B 3
[/tt]
[li]Which columns define the key of the table?[/ol] Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm