title: How do I add columns to data from a Flat File Source in SSIS?
body: <p>I have a Flat File Source that reads data from a file with two "columns" of data. One is an ID and the other is a date. I want to read this data from the file and "dress" it with two more columns before I write it to the database. I want to add one column with the value of getdate() and one column with just a 1 in it.</p>
  
  <p>How can I do this?</p>