dbTalk Databases Forums  

Best way to laod a file with header and detail infromation

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Best way to laod a file with header and detail infromation in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John230873
 
Posts: n/a

Default Best way to laod a file with header and detail infromation - 03-24-2006 , 05:05 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.