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 |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2009-09-24 : 15:56:59
|
| hi there,I know little about SQL XML and i wonder if sql can read an xml file and retrieve the data there to save into sql table? please give guide and really appreciate this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-25 : 14:27:44
|
| yup. it can . if you want to pass xml from file you can use dataflow component in ssis with xml source and if you want to directly pass the xml value just make a xml parameter and pass xml through it and use xml functions nodes(),query()... to retrieve the values |
 |
|
|
|
|
|
feed table with an XML file