March 29, 2010 at 7:48 am
What i'm looking to do if possible is pull a recordset in sql from a page that generates xml. Is this possible? If so how?
March 29, 2010 at 1:39 pm
A lot more detail is going to be required to get a good answer.
March 29, 2010 at 3:10 pm
I have two servers, one is a production server one is used by customers. They can not talk to each other for security reasons. Meaning I can't link them in anyway. Currently we download xml in either asp or php in order to display the information. We wrote a class in asp and in php that parses the xml file and turns it into an array that we then display. What I would like to be able to do is instead of using asp or php to parse through the xml I would like to do it in sql and either dump it into another table or just pull it into a recordset. The reference of the xml file is actually a webpage, so I would need to point my sql statement at this webpage. I would like to know if this is possible.
Thanks in advance for any help.
March 29, 2010 at 10:02 pm
do it in CLR, or SSIS. Using T-SQL is going ot be a crude, dangerous way to do it. You can always trigger these things from within T-SQL.
You're going to wsnt to do it somewhere with the appropriate abilities to parse and scrub whatever you might tbe taking in. It also will allow you to get a better handle on security. T-SQL "native" is frankly not well suited for this kind of access, and would require opening up access you don't want.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 30, 2010 at 7:26 am
Could you point me in the direction on how to do that is SSIS?
March 30, 2010 at 9:29 pm
Just wanted to confirm so it took me a little longer to get free. That said - it's actually straightforward: in a data flow task in the SSIS package, pick an XML source, and give it a URL for a location. Everything else is essentially the same.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 31, 2010 at 11:10 am
awesome i will check that out
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply