-
DTS: Dynamically Building SQL String
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|