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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy