dbTalk Databases Forums  

DTS Urgent Qry

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


Discuss DTS Urgent Qry in the microsoft.public.sqlserver.dts forum.



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

Default DTS Urgent Qry - 06-18-2008 , 09:57 AM






I have a DTS Package where there are 4 tasks all connected to each other with
OnSuccess flow , the first task is collecting all the files from FTP
and dumping in a STAGING area and then those files from STAGING area are
taken and processed with the next 3 remaining tasks.
Individually all the task is working fine, but when I run the entire package
the first task where it is taking the files from FTP location is taking time
but
it is declared success and goes to the next step, although the FTP process
is still running and has not finished dumping the files to staging area,
so on the next step it is not getting the files from the concerned location
as the FTP is not finished. Please let me know how to make sure that once
this FTP part
is over then only it shuld go to the next step

Reply With Quote
  #2  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM






Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #3  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #4  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #5  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #6  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #7  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #8  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #9  
Old   
Maninder
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-18-2008 , 08:45 PM



Try changing the pumptask to on success rather than on completion.
see if this makes a difference.

Reply With Quote
  #10  
Old   
matteus
 
Posts: n/a

Default Re: DTS Urgent Qry - 06-19-2008 , 03:48 AM



On Jun 18, 4:57 pm, Nitin <Ni... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
I have a DTS Package where there are 4 tasks all connected to each other with
OnSuccess flow , the first task is collecting all the files from FTP
and dumping in a STAGING area and then those files from STAGING area are
taken and processed with the next 3 remaining tasks.
Individually all the task is working fine, but when I run the entire package
the first task where it is taking the files from FTP location is taking time
but
it is declared success and goes to the next step, although the FTP process
is still running and has not finished dumping the files to staging area,
so on the next step it is not getting the files from the concerned location
as the FTP is not finished. Please let me know how to make sure that once
this FTP part
is over then only it shuld go to the next step
This message has been posted twice.
I've asked to delete it.

M.


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.