Hi

I am writing a package that i want to have email me on two possible success
scenarios.

essentially, this is the conditions:

IF @result = 0
BEGIN
EXEC master..xp_cmdshell @copyfile, NO_OUTPUT
PRINT 'Operation Successful'
END
ELSE
BEGIN
PRINT 'This operation failed. Error Code:01. The source and destination
files are identical.'
END


If the first condition is met, I want to fire off an email stating success.
If the second condition is met then i want to fire off a different email.

Now, the problem is, I am not sure how to flow it. Both conditions are
successful, thus it always fires off the success email if i use an "On
Success" flow.

How do i capture the error i want to create before the email to tell it
which email to send?

Does this make sense?

Duplicate post. Please refer to other posting...

--
HTH. Ryan
"JuiceN" <JuiceN (AT) discussions (DOT) microsoft.com> wrote