Inserting a loadtimestamp into a SQL table during a data load run via DTS package

I have a DTS package that loads data from a spreadsheet that is extracted from another system.  I want to be able to insert a date/time stamp for when this data is loaded and I cannot figure out how to add this to my DTS transformation task using SQL 2000 DTS.  I have an excel source and an OLE DB destination table defined with the loadtimestamp column already defined, but I cannot figure out how to add an insert of the current date//time into the Data Transformation taks that loads the data from the spreadsheet into the table.  Any guidance woiuld be appreciated.Start Free Trial