XML,XSD and XSL usage in ssis

• kiruthika.naren

  Valued Member

  Points: 70

  More actions

  June 8, 2011 at 11:50 pm

  #238864

  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

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  June 9, 2011 at 9:50 am

  #1336449

  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