Here is my task.

I want to know if I can set up a DTS package that when run by the SQL Server
Schedule will use DATE()-1 AKA: GETDATE-1
But when it is run manually, via right clicking on it. Will prompt for a
date to be used.

Any suggestion?

Thank you in advance.
Kent Prokopy

Kent,

Set up one more global variable to keep the invocation type. Set the default
value to 'Manual'. When executing on schedule reset variable to 'Schedule'.
Add an ActiveX task to pop up an input box or default whatever carries the
dates to DateAdd("d", -1, Date()) depending on the invocation type.

Ilya

"Kent Prokopy" <kent_prokopy (AT) hotmail (DOT) com> wrote