Hi,

I have an xml file the content which i have to write to a Database table using ssis pacakge.

I am using xml source nad oledb destination

My issue now is this xml file generate multiple outputs .(event,produt,offer,form) etc. But i need to write all in one data row(more than one if 2 products are there for the event) in the database.

But i do not know how to use this multiple outputs and make a single row for a event.

I hav read numerous articles about this subject but not able to take a decision.what is the right way of doing this.

1) xml source ? (if i use this how do i merge the multiple outputs) 2) or a script task using xml objects read and write to the DB.

or anything new ?

Please provide me some solutions

xml sample file * - ABc. 2009-06-07 2010-04-30 region test 1 contact - offertest

• product1
  • product1
  • 
    187 *

Thanks

SNA