Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fishern
Starting Member
4 Posts |
 Posted - 2004-05-02 : 10:16:25
|
| My Problem.I have a source XML file.I have to get this data into a SQL server table using Bulk Load.I have one key field missing.The key field can be obtained if I joint a numnber of elements from the Source XML file to another table in the SQL Server Database.I understand that I need to create a VBScript within the XDR to do this.Does anyone have the time to help me.Thanks |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-05-02 : 10:41:54
|
| Not my area of expertise, but it sounds like a staging table would help solve the problem of the missing column. - Build the staging table with the XML contents - JOIN the staging table to derive the missing columnINSERT INTO MyFinalTable (cola, colb, ... ) SELECT ... FROM StagingTable ST INNER JOIN ... |
 |
|
|
|
|
|
XML Bulk Load