April 5, 2012 at 7:18 am
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
April 5, 2012 at 7:53 am
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply