Hi all,

I setup a dts that will execute an SP everyday. My SP requires parameter to
execute in which i need to supply the date of the day. I just want to know
the code for getting the current date and how to use it as parameter. I
would appreciate any help.

example format:

Execute MyStoredProc '07/20/2003'

thankx
joel