title: Export sql server query output from ssis to text file INCLUDING THE COLUMN HEADERS
body: <p>I have been trying to export the output of a SqlServer sql query (stored procedure) to a text file.
  I achieved it using a Data Flow task  with an OLEDB source and a Flat File Destination.</p>
  
  <p>I would also like to get the Column headers along with the query result in the text file , but I cannot figure out how I can include the column headers.</p>
  
  <p>I would like to do this dynamically from within SSIS </p>
  
  <p>Is there anyone who knows how to do this ?</p>