I have and ActiveX Script Task that transferes a file over FTP.

I then have an ActiveX WorkFlow script that checks to see whether the file
has been downloaded.

If so I pass DTSStepScriptResult_ExecuteTask or
DTSStepScriptResult_DontExecuteTask if there's no file.

The problem seems to be that the workflow script is executing before the FTP
has completed and therefore always results in a don't execute (t least that
waht i think!)

Any ideas ?

Yep the workflow script of the task executes before the task itself.
After you have tried to download the file then I would use workflow in
the main script to decide whether to go any further. A good reason for
this is that it is more visible than the Workflow Script. You can see
examples of having conditional execution in the workflow here

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)


Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)


Allan


"M Dodsworth" <MDodsworth (AT) discussions (DOT) microsoft.com> wrote