SSIS - Import from Excel to SQL Table
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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.