I'm moving data from Oracle 7.3 into SQL Server 7.0.

Each day I want to load only those transactions that took place that day. To do this
I need to either build a parameterized query in the DataPump Task (on the data source side)
or build the query dynamically in a preceeding VBScript Task. I have been unable to
figure out how to to do either. Can someone please help?

Thank you,
- Bill