Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Problem building a file with SSIS package

Author  Topic  maxjam Starting Member 9 Posts Posted - 2010-12-15 : 10:16:03 hi all, have to create a file in the following format: File Header ---Data Header 1 EUR ------Record 1 EUR ------Record 2 EUR ------Record 3 EUR ------etc ---Data Header GBP ------Record 1 GBP ------Record 2 GBP ------etc ---Data Header USD ------Record 1 USD ------Record 3 USD ------Record 4 USD ------Record 5 USD ------etc ---etc File Footer CREATE FILE HEADER CREATE DATA HEADER(s) AND RECORD(s) There can be any number of data header + records: I have to open a table, find out how many currencies there are in it, for each currency i create a new data header. Then go find all records in another table with the same currency. Write this information to a file. Repeat this process for all currencies found and constantly append this information to the file. CREATE FILE FOOTER Can anyone suggest how to best approach this in SSIS, I have most of the SQL code written but am at a loss on the SSIS side....