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 2 (of 2 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