i am creating a DTS package that will query a table and move data to another table daily on same DB/SERVER. i want to be able to timestamp previous date into date column in destination table. There's no date on source but i need timestamp on each import and date for previous day b/c importing data are for previous day.
Just include those expressions (the stuff after the equal sign from my previoius post) in your query. Be sure to give them some column name, and it will be a lot easier if you give them the column names you want used in the destination table.