January 26, 2006 at 11:54 pm
Hi All,
I have a requirement to upload XML file in to a table. The data in XML file corresponds to five columns (A1,A2,A2,A4,A5) in Table A.
XML File:
<Details>
<Header>
Name|Age|City|Country|Experience
</Header>
<Data>
Peter|25|Sydney|Australia|5
Stewart|27|Canberra|Australia|7
Russel|35|Roads|Australia|10
</Data>
</Details>
shed some light on this, Please?
1. What are the possible ways to do this?
2. Shoud a db user have any speciall privellages?
I am new to data transformation services. Any help in this area would be great.
Thanks,
Mani
January 27, 2006 at 1:22 am
You want to take a look at the SQLXMLBULKLOAD process. There are lots of threads on the site but I had a similar problem to you and got quite a detailed response.
February 13, 2006 at 5:00 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply