Here was my final solution:

I used ADO in an ActiveX Script to generate the sourceSQL string, stuffed it in a global variable, then assigned this string to the sourceSQL string of the Oracle Data Pump Task by using the Dynamic Properties Task. It was really easy. The Dynamic Properties Task is a new feature in 2000. Back in the old days, all of this had to be done programmatically in an ActiveX Script referencing the various package objects in code.

Thanks to those who replied. I hope my answer prompts some of you to start using the Dynamic Properties Task in your DTS packages.

Cheers!

J. Moseley