Single Excel Source output to Multiple Excel destinations

• Dom Horton

  SSCrazy

  Points: 2202

  More actions

  May 15, 2017 at 6:55 am

  #325812

  Hi all,

  Hopefully someone can point me in the right direction.

  I have a single excel file following the below format:
  

  This shows details of orders & corresponding order lines. The problem I'm facing is that there's no unique Order Reference (or similar). The only thing denoting each order is column G showing end_of_order.
  So, the first order comprises lines 2 & 3. Next Order is Line 4 (just 1 line), likewise for the next Order (row 5). The next order then comprises lines 6,7,8 & 9. And so on.
  What I need to do is output the orders into separate xls files (one for each order). I'm struggling on how best to iterate through the source xls, read the rows to the end_of_order and then repeat for the next order. (I've looked at conditional splits; using scripts to calculate row numbers, For each loops, using recordset destinations to temporarily hold data....but I keep going round in circles!)
  I'd really appreciate some pointers on how best to approach this.
  Many thanks,
  Dom

• Dom Horton

  SSCrazy

  Points: 2202

  More actions

  May 16, 2017 at 7:53 am

  #1942697

  Solved.
  Went down the route of using SQL table to hold intermediate results. Then queried that to get xls output.