fajitapete1
MIS
I am lookinh for an example of how to use XML Bulk Load to load data to a sql table. I have a url access that returns mutiple rows of data that I wish to load to a table. when I access the url I get this back in a browser window:
<?xml version="1.0" ?>
- <zip-three-coverage xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<dbo.tblActivezip3 zip3="001" />
<dbo.tblActivezip3 zip3="010" />
<dbo.tblActivezip3 zip3="011" />
</zip-three-coverage>
Up to now I am cutting and pasting to a text file and then importing. I know there has to be a better way, idealy I could combine bothe the url as source and the table as the target. any help, directions really appreciated.
<?xml version="1.0" ?>
- <zip-three-coverage xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<dbo.tblActivezip3 zip3="001" />
<dbo.tblActivezip3 zip3="010" />
<dbo.tblActivezip3 zip3="011" />
</zip-three-coverage>
Up to now I am cutting and pasting to a text file and then importing. I know there has to be a better way, idealy I could combine bothe the url as source and the table as the target. any help, directions really appreciated.