Home > Archive > MS SQL Server DTS > March 2006 > Best way to laod a file with header and detail infromation









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Best way to laod a file with header and detail infromation
John230873

2006-03-24, 7:39 am

I was wondering wouuld would be the best way to load in a file with headeer
and detail information about records.I have found that an example that show
these biut the difference in my case is that the start an dfinsh of a row is
a tag and the tags are different for the headers and details
Here is an exmaple of the upload file
<T5>
1:1514709
4:SH87362-2
8:2006032308082600
17:EX200864024NZ
</T5>
<T6>
1:1511316
3:18122755-00
5:35505012
6:1
17:EX200866250NZ
25:0000262473
</T6>
<T6>
1:1514454
3:18168691-00
5:31806034
6:2
17:EZ200862448NZ
25:0000268373
</T6>

in this example one type of record is between the <t5> and </t5> tag and the
other is between the <t6> and </t6> tags. The thing I do know here is that
the number of lines for th et6 and t5 always stays the same eg t6 has 8 line
start to finsh and t5's have 6 lines.
I was thinking mybe using the top x componet but unsure if this would help
in this case.

Any ideas
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com