I am very new to SSIS. What I want to do is to query, then write each record to text files.
Sample : record 1, account # 123, create a file called 123.txt and then write the rest of the data in this format
customername | Jim Thompson
address | 123 S. La Cruz
city | San Francisco, ca 95555
Record # 2 account # 345 create text file called 345.txt and write the rest like above.