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 - 2003-03-24 : 07:46:26
|
| Bill writes "We are running SQL Server 2000 on WINDOWS 2000.My DBA has set up a process that sends emails every time a Failure is detected in a step. I want to split the path followed in the DTS without having an error condition created.Specifically, I want to detect the presence of a file, check that there is data in the file, then process the file. If there is no data to process I want to stop execution of the package without receiving an email.I have been using an ActiveX Script Task to detect the file's presence, but can only have a Success or a Failure coming out of it. The 'Failure' causes an email to be generated, even though this is only a 'Stop Processing' condition, not an error." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-03-24 : 07:57:01
|
| Rather than failing the step when the file is not present, you should set a global variable and then use a conditional to send the mail based on the value of the global variable.Jay White{0} |
 |
|
|
|
|
|
Stooping execution of steps in DTS pacage