DTS input from Excel

[SQLScholar]

Hey all,

I am creating a package to insert an excel file into our DB. Some of the fields are given on the spreadsheet but not all.

One field i want to be todays date, so i have put in Getdate() as fieldname,

but i am getting back an "undefined function in expression getdate".

Any ideas how i can do this?

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------

 

[gradley]

There are a couple of options i can think of:

1. Add an Execute SQL task after the import to update the date field for all records with GetDate().
2. Set the Default Value of the Date field in your table to use GetDate(). This is definately the easier option.