xml destination

• sent_sara

  Newbie

  Points: 3

  More actions

  December 18, 2010 at 1:50 am

  #144341

  Hi,

  I have a conditional split,from which the output comes as:

  Emp Dept

  E001 HR

  E002 HR

  E009 HR

  I need to store this output as xml into an output.xml file..since there is no xml destination,iam stuck to continue..can anyone help me?

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  December 29, 2010 at 8:44 am

  #1267229

  I would recommend downloading this excellent piece of freeware called XMLIFY from here[/url]

  Run your data flow through this component and select the 2 fields you want to convert into XML.

  Use a flat file destination component and name the file output.xml in the flat file connection manager.