Hello,
I want to import some XML data from the internet. For example, http://www.somexmldata.com/ returns some well formatted XML data that I want to import into SQL Server 2005.
If I create an Integration Services Project it's easy - I use an 'XML Source' and specify the URL as the 'XML location'. Job done!
However, I want to do it using the Data Import Wizard - how do I accomplish the same thing
Many thanks,
Ben
Quick Import Wizard Question - Importing XML Data
Hot Topic
- SQL Server connection from C#/asp.net
- Service Broker in Express edition
- Flags on a table
- Management Studio Scripting Bug?
- Very slow GROUP BY with SQL 2005 on 64bit Multiprocessor Server
- Is Metadata Report Tool Ready for SSIS
- RS on the Internet - security issues
- Enforcing integrity within the XML type
- TSQL equivalent of Fuzzy Lookup in SSI - Is There?
- SQL Looping for Complex Query
SQL Server
- Shared Datasource
- Audit Transformation error
- Does SSIS have these features????
- How to group the columns?
- "Jump to URL" Navigation option - Window.Open method is not Working
- SQL Server CTP 16 - Failure to set maintenance plan
- Second instance of Reporting Service cannot get to web page
- Error processing events
- I hate this
- Reports in Lanscape
Quick Import Wizard Question - Importing XML Data
Skizznott
That is something that should be part of our upcoming work.
You are welcome to request that at the product feedback site.