Execute a DTS Step if a condition is true.

[MrPeds]

Hi,

this is another newbie question I'm afraid, so apologies.

I have a simple DTS package with 3 steps so far, these are:

1) FTP: download a csv file
2) ActiveX: determine the creation date of the csv file. If the file is over a certain age, set a global variable to True.
3a) ActiveX: If the Global variable is true, then execute a send email Task telling me the details.

I am stuck on step 3a. I want to continue executing other steps after step 2 has finished in parallel, but I am not sure how to specify in ActiveX if my email task should run. in pseudo code i want it to do this:

If (GlobalVariable=true) then
ExecuteEmailTask
End if

How do I do this? Do i have to do it in code or in Workflow.

Thanks,

MrPeds

 

[Krickles]

Check out workflow rules. You can set parallel execution of your first two steps and then make a workflow rule (3a) that will conditional move on to a next step based on the result (true/false).

Hope this gets you going in the right direction.

Krickles | 1.6180