export each row of the sql table to a xml file respectively

• sneha.saiholli

  Valued Member

  Points: 55

  More actions

  July 27, 2010 at 1:45 am

  #387434

  I have tried and successful in exporting the whole sql table to one xml file by using SSIS- Script component by using the below site:

  http://agilebi.com/cs/blogs/jwelch/archive/2007/06/01/xml-destination-script-component.aspx

  Need to export each row of the sql table to a xml file respectively. i.e. if there are 5 Rows in the sql table then 5 xml files need to be created.

  Please guide

• sneha.saiholli

  Valued Member

  Points: 55

  More actions

  July 27, 2010 at 4:19 am

  #1198617

  Hello...!! Thanks a lot for the reply. 🙂

  Could you plz elaborate the steps on how to go about.

  I have not worked on SSIS much. so getting very much confused.

  Thanks and Regards

  Sneha

• lthamanam

  Valued Member

  Points: 65

  More actions

  July 27, 2010 at 6:18 am

  #1198641

  hi,

  try with this

  select * from tablename for xml raw