June 8, 2011 at 11:50 pm
Hi All,
I have 3 XML files. In which all the 3 files have multiple namespave defined.
Help needed for :
1. How to remove multiple name space
2. How to get the base XSD for all the 3 files.
3. I have one node which is having attribute id and the value in it.
<CREATEDATE dt="date">2011-06-05</CREATEDATE>
<CREATETIME dt="time">18:23:05</CREATETIME>
How to get the values of the above. For example. date 2011-06-05
please help me out in getting all thes.
Thanks in advance
June 9, 2011 at 9:50 am
kiruthika.naren (6/8/2011)
2. How to get the base XSD for all the 3 files.
If these files are sent for a business purpose it would be best to ask the source for a schema document to go along with their files.
That said, if your hands are tied, SSMS has a nice XML editor built into it that can generate schemas. Open the XML file in SSMS (File | Open). When an XML file is open a menu not available while a query window is open, the XML menu, becomes available. From the XML menu select "Create Schema". Note that SSMS cannot read your mind so the schema it generates will be a least common denominator, albeit it will be a valid one usable with an SSIS XML task.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply