 | |
#1
 
| |||
| |||
|
DTS getting to next task before finishing the first -
06-18-2008
, 09:46 AM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
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 |
#7
| |||
| |||
|
|
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 |
#8
| |||
| |||
|
|
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 |
#9
| |||
| |||
|
|
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 |
#10
| |||
| |||
|
|
What precedent constraints do you have between the steps. If no contraints exist then there is potential that both steps will run at the same time. -Chris "Nitin" wrote: 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 |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.