Use OPENROWSET BULK with http - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Use OPENROWSET BULK with http

Author

Topic

benn
Starting Member

2 Posts

Posted - 2009-09-07 : 15:22:37

Hi,

I would like to read an xml and get a value from it but the xml file is returned via the folowing url:

http://maps.google.com/maps/geo?q=MyPostalCode&output=xml&key=MyGoogleMapAPI_Key

where MyPostalCode is a postal code
MyGoogleMapAPI_Key is my google Map Api key that I received when registered.

To read the xml file, I used the folowing code :

select * FROM OPENROWSET(BULK 'http://maps.google.com/maps/geo?q=MyPostalCode&output=xml&key=MyGoogleMapAPI_Key',SINGLE_BLOB) as c

but I am getting the following error:

Cannot bulk load because the file... could not be opened. Operating system error code 123(error not found).

Does anyone know how to fix this issue?

benn
Starting Member

2 Posts

Posted - 2009-09-08 : 22:29:10

Any idea???

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources