We help IT Professionals succeed at work.

Getting XML data from a web page into SQL Server 2008

227 Views
Last Modified: 2010-03-20
I am using SQL Server 2008 Evaluation copy and have a specific requirement to retrieve some XML data off a web page for import into SQL. The process is
1. Login (e.g.)
http://dev.site.com/login.aspx?email={Username}&password={Password}
2. Define Time Interval, fetch XML data (e.g.)
http://dev.site.com/GetRawPerf.aspx?MyId={MyId}&St
artDate=20071106&EndDate=20071206
- The above (with the correct URL) returns data into the browser if I do it manually, but how do I "capture" it into SQL?
I have tried using the Web Service Task and the XML source within SSIS to login and fetch the data but to no avail. Apologies for the Beginner nature of this 'ask' but I just want to establish if it is possible.
Comment
Watch Question

Topic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
XML into SQL is a dud and a fraud. Why oh why would you not include the ability to consume web driven xml straight into SQL? Did Microsoft now expect it that XML would need to be consumed in this way? Let's face it XML is treated by most people as a CSV mark II.
Mark WillsTopic Advisor, Page Editor
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
@simdk: agree coming straight from a website, but as a standalone file a-la csv then it does work pretty well - in 2008 that is, you should have tried some of this back in SQL 7.0 days - now that was nasty...

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.