SQL 2008 - SSIS
I have 5 Columns in the Excel Sheet -
While Importing to SQL Table, i need to add or include DateModified Field in the SQL Table.
DateModified Column is not in the Excel Sheet. We need to mention in the SQL Table which help us to understand the date of Import.
Do i need to add a Trigger ?
How should i do this ?