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.)
2. Define Time Interval, fetch XML data (e.g.)
- 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.