Need to create a ~2,000 flat files with specific structure in MS SQL : The .control files I need to create contains a specific structure that will be used to fax certain documents to specific destinations. Here is a sample:

    ;Sender Information
    #SENDER_NAME LA Medical Care
    #SENDER_EMAIL LAFakers@gmail.com
    #SENDER_BUSINESS_FAX_NUMBER 213-555-4321
    ;RANDLE, JULIUS's Information
    #RECIPIENT
    #RECIP_NAME RANDLE, JULIUS
    #DESTINATION 1-323-555-6789
    #ATTACHMENT Report_Randle1.pdf

For every flat file, the sender information will be the same but the recipient information is what needs to be dynamic. I have a table that can provide the RECIP_NAME, DESTINATION, and ATTACHMENT parameters. Any ideas on how to start this query? Thank you.