Variable initialized by user each time DTS runs?

[antonopn]

Hello there,
thank you for your time!

Here is my problem. I have a dts package that sould run monthly. The user should set a date each time it runs. This date is a variable that used in the dts. How should I do this?

VB Active X?

Thank you very much!!!

[ck9663]

Hello there,
thank you for your time!

Here is my problem. I have a dts package that sould run monthly. The user should set a date each time it runs. This date is a variable that used in the dts. How should I do this?

VB Active X?

Thank you very much!!!

Can you pass parameter to DTS?

-- CK

[antonopn]

I suppose you can pass parameters. I do not know how to do it.
The end user should input a date. This date will refer to a variable that will be used in the DTS.

Thank you!!!