title: SSIS - add upload date column after SSIS upload
body: <p>I'm uploading a daily CSV file via a SSIS package to a SQL Server table and each time would like to insert a date column that states when the upload was complete. I'm thinking of putting in an Execute SQL Task after the Data Flow Task which uses a <code>ALTER TABLE</code> query with a <code>GETDATE()</code>. </p>
  
  <p>Each time I run the SSIS package before the CSV data is uploaded the previous data is moved to an Archive table so there won't be any worry of overwriting data each time I insert a column.</p>