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,
BenUnfortunately, we were not able to add support for XML sources to the Import Wizard.
That is something that should be part of our upcoming work.
You are welcome to request that at the product feedback site.
No comments:
Post a Comment