I am making a DTS package that will import several columns from an
Excel spread sheet. I will be appending these imports to a table on the
SQL server. As the Excel spread sheet I get comes from several people
and are all named then same I need a time stamp each time the DTS
package runs. I already have a unique ID number for each person. The
Excel spread sheet dose not have a time stamp on it. Plus for other
reasons I need to record only when the server runs the DTS package, not
when the person submitted the sheet.

I have ever real ran DTS packages except to do one time imports or
exports. I tried using the DTS wizard to set up a scheduled package.
The problem I am having is figuring out where I can declare the time
stamp.

Any help would be helpful...

Use the getdate() function as a value for an INSERT or UPDATE operation

Jim

"Data_Monkey" <Eric.Tashchian (AT) navsoc (DOT) navy.mil> wrote

OK so what you can do is this

The SQL Server table has a DateTime on it right ready for you?

In your transformations tab

Choose the destination column ONLY
Click New
Click Active X Script
Click Properties

In there enter something like

DTSDestination("Column Name Goes Here") = Now()


OK out of that.

When you look at your transforms now you should see that you have an
arrow pointing to the destination column but it orginates from somewhere
out of the top of the sheet.

If you need more help shout.

Allan

"Data_Monkey" <Eric.Tashchian (AT) navsoc (DOT) navy.mil> wrote

Thanx Allan!
That just what I needed. I did not realize that how to import a from
some where outside the connections I was working with. The
Transformations section was all new to me...