jschultz0614
asked on
how to import xml from a website, parse it and save the results into mssql 2k8 r2
OK...
I have an external XML web site (http://rss.timegenie.com/forex2.xml) that I need to import into MSSQL Server 2008 R2.
1. is this even possible?
2. how would this be done?
Thanks,
John
I have an external XML web site (http://rss.timegenie.com/forex2.xml) that I need to import into MSSQL Server 2008 R2.
1. is this even possible?
2. how would this be done?
Thanks,
John
Here are some good examples
http://stackoverflow.com/questions/3628846/insert-xml-into-sql-server-2008-database
Get the insert working outside of your site, them get a simple insert working, and only then put it all together. Too many things can be a problem when doing it all at once.
http://stackoverflow.com/questions/3628846/insert-xml-into-sql-server-2008-database
Get the insert working outside of your site, them get a simple insert working, and only then put it all together. Too many things can be a problem when doing it all at once.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
getting the following error:
Msg 4860, Level 16, State 1, Line 51
Cannot bulk load. The file "c:\ee\forex2.xml" does not exist.
I created the ee directory. The script works only if I manually download the xml file myself.
Msg 4860, Level 16, State 1, Line 51
Cannot bulk load. The file "c:\ee\forex2.xml" does not exist.
I created the ee directory. The script works only if I manually download the xml file myself.
ASKER
Disregard :), forgot to create the js script :D.
AWESOME SCRIPT btw.
AWESOME SCRIPT btw.
ASKER
Awesome Script
Thanks, I have been using it for a while now, and (so far) it stands the test of time...
Cheers,
Mark
Cheers,
Mark
Mark_wills,
Please help on this also: https://www.experts-exchange.com/questions/28008319/step-by-step-guide-to-installing-sql-server-2008-R2-on-standalone-machine-not-cluster-SP2-CU4.html
Please help on this also: https://www.experts-exchange.com/questions/28008319/step-by-step-guide-to-installing-sql-server-2008-R2-on-standalone-machine-not-cluster-SP2-CU4.html
ASKER