SSIS - Importing data file and creating .csv outbound file

• jchappell 92664

  Say Hey Kid

  Points: 689

  More actions

  April 5, 2012 at 7:18 am

  #254452

  Good Morning. Needing some assistance in SSIS. Fairly new to this technology. Here's the issue:

  I have a data file coming out of 1 system. It's PO information with multiple records per PO. I need to create a .CSV file out of this to go into another system. So, if there's 3 records on the source file for a PO, the .csv file would have 1 header record with the total cost of the PO and other relevant info. The detail would then have 3 records for each line of the PO with the individual cost for that part.

  I have my data flow with the data file as the source. My question is how to do I create the header and detail for each PO on the source file??

  Thanks in advance for any help.

  John

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 5, 2012 at 7:53 am

  #1469524

  Duplicate post, please post on this thread, http://www.sqlservercentral.com/Forums/Topic1278748-391-1.aspx

  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