Link to home
Avatar of chokka
chokkaFlag for United States of America

asked on

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 ?
ASKER CERTIFIED SOLUTION
Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial