Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-30 : 11:48:22
|
Ray writes "I am checking for the existance of an FTP'd file. Using the FileSystemObject is no problem. If I find the file, I'd like to process it. Otherwise I'd like to either stop processing or more generally branch to a different task and continue.
As far as I can tell, I can use DTSTaskExecResult_Success and DTSTaskExecResult_Failure along with Precedence Constraints to conditionally branch, but what if there are three options? Besides, it seems hokey to have to return failure just to branch. Isn't there a better way?
SQL 7, NT4" |
|
|
|
|
|
DTS