dbTalk Databases Forums  

Make a task wait for another

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Make a task wait for another in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gerald Hopkins
 
Posts: n/a

Default Make a task wait for another - 05-23-2004 , 05:13 PM






I have a problem in that I have an ActiveX Script task that is supposed
to wait Upon Success of the the previous task, which is an Execute
Process task that runs a bat file to FTP some files to another machine.
The ActiveX script is supposed to delete the files after they are ftp'd
to the other machine. However, it looks like the files are getting
deleted before the FTP can happen. Is there a way to make the ActiveX
task wait until the ftp is finished? Should I move the ActiveX deletion
task to a different package and schedule it to execute a significant
period of time after the package with the ftp?


Thanks,

Gerald

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

Reply With Quote
  #2  
Old   
Ashish Ruparel [MSFT]
 
Posts: n/a

Default RE: Make a task wait for another - 05-23-2004 , 10:40 PM






Hi Gerald,

What you need to do is set the workflow property.

Right Click on the Activex Script, in the Design Mode.
Select Workflow -> Workflow Properties option.
In the precedence tab, click on New
Select the Source step (The Task that should precede the Current Task)
Select the Precedence
The Destination Step would be the Current Task.

Thus when the Source Step completes with the selected precedence (Success /
Failure / Completion) the destination step will be executed.


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


Reply With Quote
  #3  
Old   
Gerald Hopkins
 
Posts: n/a

Default RE: Make a task wait for another - 05-24-2004 , 01:15 AM



Thanks for your response, Ashish, but I'm already doing that. The
problem is that the FTP is taking a few seconds after the task generates
the "successful" message and prompts the subsequent ActiveX task to
begin. I need a way to get the ActiveX task to WAIT until the FTP is
finished, OR I need to move the ActiveX task to another package and
schedule it well after the FTP's are expected to finish.

Thanks,

Gerald

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

Reply With Quote
  #4  
Old   
Ashish Ruparel [MSFT]
 
Posts: n/a

Default RE: Make a task wait for another - 05-24-2004 , 07:29 PM



Hi Gerald,

It would be better idea, that you set the script in a different package and
schedule it after proper time gap.

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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.