title: Folder Structure In SSIS for Output file and naming convention of Output file
body: <p><strong>SSIS</strong></p>
  
  <p>This is <strong>general question</strong> which i am going to ask and might <strong>possible to have multiple answer.</strong></p>
  
  <p>Techie, please share with me the best solution if familiar with scenario.</p>
  
  <p>i have 100 customer and they share file for us to load into our database.
  and after compution and the output file need to be saved in Output folder.</p>
  
  <p>the name of the output file should be customer_name.txt where customer_name
  is coming from a column available in input file.</p>
  
  <p>Can anyone please help me how should i design this in <strong>SSIS</strong> to achieve my Goal</p>