Sapen (6/5/2012)
Thanks for your valuable inputs everyone.I apologize for not posting my question clearly. The xml file is not always a same file instead a new file gets created with a new name every 2 minutes and I need to capture data from each file as it gets generated, although the content appears to be same as posted earlier. As of now I dont have the destination table created yet. But I will need only the below columns.
applicationId
startTime
startDate
direction
durationMinutes
token
bridged
callerId
sessionId
dialString
Once I have a query ready I can create a table accordingly and use it in a package and have it scheduled as required. Thanks for your help in advance again.
All you need to do is add the columns you want to the query I wrote. Copy-and-paste and a tiny bit of typing. That should give you what you need on the XML query.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon