Does anyone have an example of prompting the user for a beginning and ending
date when running a DTS package that doesn't involve input boxes? Optimally,
I'd like to use 2 DateTimePicker controls and then feed the dates chosen to
a stored proc I'm running in a DTS package. Can I do this with an ActiveX
script task or do I have to write a DTS custom task to do it? I'm familiar
with vbscript and VB6 as well. I also was thinking of just writing a VB app
with 2 DTP controls and having that create and update a temp table. I can
call it with an execute program task and use dynamic SQL to run the SP in
the DTS getting the dates from the temp table.

I'm just brainstorming out loud which tends to work much better when you
have the ear of lots of smart people. Any other suggestions or comments on
my thoughts?

TIA

Matt