A client would like to pull results from a table and export each row to it's own separate file. I am trying to use SSIS to do this. I have the sql query ready in a data flow task, but I'm not sure how to setup the variables to put each result row into it's own file and then name the file a particular name. The file name will be part of the row result. I am only pulling two fields from a table to get my results. The first field is an ID field which will become the file name. The second field is a data type of text and will go into the .doc file. Any help would be appreciated. Thanks.