Creating XML file using Excel Data

• A Little Help Please

  SSCarpal Tunnel

  Points: 4764

  More actions

  September 18, 2009 at 8:20 am

  #103824

  I need to create an XML file populated by data from a CSV file.

  I have the following XMLSchema template:

  xmlns:cmn="http://www.test.co.uk/XMLSchema/DataFeedCommon-v1-2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  1.1

  123456

  IIBS

  2009-03-12

  March09

  123789

  123789false

  N

  123456

  2009-02-2708:02:00B

  PStock

  I

  2009-03-31

  F103836GBP3

  QWERTYU

  XXXX

  All the data highlighted in BOLD above will come from an excel (csv) file.

  At the moment as a work around im using a MS Word Mail Merge, this is not ideal, can his be done using a SSIS package?

• A Little Help Please

  SSCarpal Tunnel

  Points: 4764

  More actions

  September 21, 2009 at 4:29 am

  #1056138

  Any suggestions?

• Edward Boyle-478467

  Ten Centuries

  Points: 1165

  More actions

  September 22, 2009 at 6:44 am

  #1056721

  Can you send a sample of the CSV file.

  Are you updating the XML or creating new records?

• A Little Help Please

  SSCarpal Tunnel

  Points: 4764

  More actions

  September 23, 2009 at 1:06 am

  #1057290

  I have attached the XML DATA FILE (CSV).

  The final CSV will be updated manually every day.

  After the update I was to convert it to the XML file.

  Thanks

• vsmeruga

  SSC Veteran

  Points: 291

  More actions

  May 8, 2013 at 8:34 am

  #1613376

  Hi Friend

  I believe you are creating this xml file for FSA report purpose and i have to create the same file. Can you please help me on this.

  Many thanks

  VJ