DTS -- Extracting Data using Date Criteria -
07-01-2008
, 12:50 PM
Hello All!
I have a DTS package that includes all records in the database:
'************************************************* *********************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'************************************************* ***********************
Function Main()
DTSDestination("ID") = DTSSource("ID")
DTSDestination("DispPos") = DTSSource("DispPos")
DTSDestination("SectorID") = DTSSource("SectorID")
DSDestination("ServerTimeStamp") = DTSSource("ServerTimeStamp")
Main = DTSTransformStat_OK
End Function
The ServerTimeStamp is a date/time column.
If I need to extract all the data for a specific day, (e.g.,
Yesterday) what modification would I need to make to this code?
Any help greatly appreciated!
RBolligner |