Create excel files dinamically in SSIS

• cesar.vargas.lopez

  SSC Journeyman

  Points: 76

  More actions

  October 26, 2011 at 11:10 am

  #390696

  Hi All

  I have a table like this:

  OrderIDProductIDUnitPriceQuantityDiscount

  102481114.00120

  10248429.80100

  102487234.8050

  102491418.6090

  102495142.40400

  10250417.70100

  102505142.40350.15

  102506516.80150.15

  102512216.8060.05

  102515715.60150.05

  I need that each one of the OrderID's will be sent to an excel file, so the three records for 10248 will be sent to 10248.xls file, two of 10249 will be sent to 10249.xls file and so on.

  Is there a way in SSIS to create dinamically excel files from a resultset based on a certain condition?

  Thanks and Regards

• Ben Teraberry

  SSChampion

  Points: 11845

  More actions

  October 26, 2011 at 11:34 am

  #1399813

  Try a google search on "dynamically create files in ssis" and you'll get a lot of information complete with code examples.

  └> bt
  

  ---

  
  Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• cesar.vargas.lopez

  SSC Journeyman

  Points: 76

  More actions

  October 26, 2011 at 1:56 pm

  #1399903

  Thanks a lot, that's been very useful. Regards!