XML CONVERTION

• raghu-sql

  Mr or Mrs. 500

  Points: 517

  More actions

  September 24, 2011 at 12:51 am

  #245400

  hi ,

  i am beginer in ssis from the "xml data source" , i learnt how to convert the xmldata and load that into

  a table or flatfile etc . How can we achieve the revse process , i mean featch tha data from a

  table or flatfile convert it to xml file .

  Thanks

  nikethan

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 24, 2011 at 7:12 pm

  #1386154

  I believe you either need to use the FOR XML syntax in T-SQL or you can use a SCRIPT TASK in the control flow or a SCRIPT COMPONENT in the data flow.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question