Thats absolutely brilliant. Worked great.
I download the xml, then i run a vbscript using sqlbulkload, to import the downloaded xml into sql.
Just wondering now, is there a way to check if a record already exists, as i may want to run this periodically to update the database?
VBscript
Set...
Hi,
Can anyone tell me how to download the data from a xml http feed? Preferably to csv,text, xml file.
I need to get the info from my http xml feed into a sql server database. i have created a mapping scheme for a xml files on my local machine and it works fine, but i need to be able to...
Hi,
I need to flatten some xml, so that each element has only one tier after the root.
The current code is
- <event>
<event_token>MXJ</event_token>
<src_code>tptd</src_code>
<area_code>PAR</area_code>
<event_code>8441</event_code>
<venue_code>DIS/T</venue_code>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.