September 4, 2008 10:18pm pdt

1. Gertone 15,250
2. TheLearn... 12,248
3. Snarf0001 7,000
4. graye 4,000
4. hielo 4,000
6. margajet24 3,650
7. pepr 2,500
7. RobSamp... 2,500
9. bigbadger1 2,320
10. philipjonat... 2,200
11. kmartin7 2,000
11. onemancat 2,000
11. zc2 2,000
11. jd_wight 2,000
11. burakiewicz 2,000
11. gova 2,000
11. willbdman 2,000
11. anarki_ji... 2,000
11. sinoj 2,000
11. willyRD 2,000
11. armoghan 2,000
11. CuteBug 2,000
11. the_crazed 2,000
11. QPR 2,000
11. Fernando... 2,000
11. ripahoratiu 2,000
11. silemone 2,000
11. snidenik 2,000
11. RedKelvin 2,000
11. joesthebig... 2,000
11. photowhiz 2,000
11. Ceiled 2,000
11. DaTribe 2,000
11. ajaysharm... 2,000
11. Chaosian 2,000
11. TechTiger... 2,000

1. Gertone 29,150
2. TheLearn... 24,648
3. drichards 8,000
4. Snarf0001 7,000
5. ripahoratiu 4,000
5. graye 4,000
5. hielo 4,000
8. margajet24 3,650
9. vbturbo 3,500
9. anarki_ji... 3,500
11. pepr 2,500
11. RobSamp... 2,500
11. vascov 2,500
14. bigbadger1 2,320
15. BobSiemens 2,260
16. kmartin7 2,200
16. philipjonat... 2,200
18. DarrenD 2,000
18. puranik_p 2,000
18. willbdman 2,000
18. QPR 2,000
18. Fernando... 2,000
18. _TAD_ 2,000
18. silemone 2,000
18. snidenik 2,000
18. rstrader 2,000
18. joesthebig... 2,000
18. zc2 2,000
18. gova 2,000
18. sinoj 2,000
18. photowhiz 2,000
18. e1v 2,000
18. armoghan 2,000
18. RedKelvin 2,000
18. CuteBug 2,000
18. realevergod 2,000
18. jd_wight 2,000
18. burakiewicz 2,000
18. onemancat 2,000
18. PatHyatt 2,000
18. willyRD 2,000
18. DaTribe 2,000
18. mrcoffee... 2,000
18. Chaosian 2,000
18. adrpo 2,000
18. TechTiger... 2,000
18. ajaysharm... 2,000
18. Ceiled 2,000
18. the_crazed 2,000
18. sumix 2,000
18. ksivananth 2,000

04.18.2008 at 09:00AM PDT, ID: 23334598 | Points: 125

	[x] Attachment Details

With SQL Bulk Load, how do I load one input field into two columns in the same table?

Asked by jschremp in MS SQL Server, Extensible Markup Language (XML), XML Schemas for .Net

Tags: SQL Bulk Load - XSD

I'm using SQL Bulk Load with SQL Server 2000, to load an XML file into a table in the database. There is one input field that I want to load into two different columns in my table. But I can't figure out how to set up the XSD file to do this.

I've tried specifying the element twice with two different sql fields:
      <xsd:element name="Id" type="xsd:string" sql:field="AccountId"/>
      <xsd:element name="Id" type="xsd:string" sql:field="FolderId"/>
This gave the following error:
Schema: unable to load schema... An error occurred... The element: 'Id' in <all> is already defined.

I've also tried specifying the element once with two different sql fields:
      <xsd:element name="Id" type="xsd:string" sql:field="AccountId" sql:field="FolderId"/>
This gave the following error:
Duplicate attribute.

Any help would be appreciated. Thanks!Start Free Trial

Keywords: With SQL Bulk Load, how do I load on…

	Title
1	How to create an XML Schema for a ta…
2	Relationship expected error though onl…
3	How do I BULK INSERT only some of th…
4	Have xsd files would like textual list of …
5	Best Practice for Bulk Copying Data fro…
6	Using XML data source for primary and…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628