DTS Package and Date

AnSQLQuery · #1 (**permalink**) 01-15-04, 11:17

I have a DTS package that imports from a text file into SQL 2k SP3. I am trying to insert a field (along with the imported fields) during the DTS execution that will be the current date. Does anyone know of a way to do this? I really didn't think I should have to schedule a seperate job to UPDATE each record with the current date...

Make sense?

AnSQLQuery · #2 (**permalink**) 01-15-04, 11:35

Quote:

Originally posted by AnSQLQuery
I have a DTS package that imports from a text file into SQL 2k SP3. I am trying to insert a field (along with the imported fields) during the DTS execution that will be the current date. Does anyone know of a way to do this? I really didn't think I should have to schedule a seperate job to UPDATE each record with the current date...

Make sense?

SRY, wrong forum....Moved it, but can't delete it now for some reason...

Internet Services

Web Development

Digital Marketing

Consumer Tech