January 24, 2003 at 7:53 am
I have been trying to find a way of accessing an http:// resource to bring XML data into SQL server. I had initially thought I should try within a stored procedure using T/SQL, but have been unable to find a way. Then I thought of DTS but cannot find any way to do that either. Currently this is working well using ASP pages running on a web site but I would like to handle the process entirely within the database if possible - can anyone offer any advice / help / pointers? SHould I be using some OLE Autmotatiuon or do the tools exists. XMLhtp is fine for passing XML OUT from SQL server, but is there any support for the reverse process?
Help / thoughts appreciated.
Alan
January 26, 2003 at 6:29 pm
There isn't a way to easily do this in T-SQL. Yukon will change that, but for now, I'd use DTS and activeX to do it. You could also port your ASP code to an object and instantiate that from T-SQL with the sp_oacreateobject.
Steve Jones
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply