SSIS - add upload date column after SSIS upload
<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>