I'm very new to writing DTS Packages. However, I have one where I want it to execute a certain package if the DayOfWeek = 1 (Monday), otherwise, I want it to do something else. I'm having trouble trying to get my ActiveX Script to recognize the 1 for Monday.

I'm guessing that I'm missing setting it up as a global variable or setting it or something? Looking for any suggestion you might have. This is the line I'm trying to use..

If DayOfWeek = '1' The

Hi,

If you want the script to check for the dayofweek for the date that it is
executed on, then
use the datepart function

if datepart(w,now())=vbMonday then

end if

If you want the script to check it against a global variable then

Declare the variable of type Integer
and then compare it
for eg

DayOfWeek int

if Dayofweek = vbMonday then

end if


vbMonday is a constant that is used with VBScripting

for more information on datepart function, visit
http://msdn.microsoft.com/library/de...us/script56/ht
ml/vsfctdatepart.asp?frame=true

HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Thank you very much for your suggestion. I gave it a try and it worked!

Since this was my very first DT Pkg and ActiveX Script, you made my day!

Lynn

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!