I'm having a problem with a DTS Send Mail task when it's
tied to an On Failure workflow task. I can change it to
on success and it works. But when I change it to on
failure and then make the task fail, it doesn't work. I
created my own simple package and used the on failure and
on success and they worked fine. This particular package
imports 2 text files into a sql table and if those
transformation tasks fail, I need it to send an email. As
I said, it works on success, but not on failure. I've
tried deleting one of the tasks so that only one runs and
when it fails, the send mail task still doesn't execute.
However on the simple package that I create, it works.
Any thoughts?
Thanks,
VanCreate a simple task in the package you are having problems with and have it
fire on failure in place of the email task. See if it fires. If it does
not, I would suggest it is a logic flow issue and not a send mail issue.
Ata R
Parvan Consulting Inc
NO_SPAMar_alias001@.NO_SPAMparvan.net
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:011c01c3d473$dfbd5280$a101280a@.phx.gbl...
> I'm having a problem with a DTS Send Mail task when it's
> tied to an On Failure workflow task. I can change it to
> on success and it works. But when I change it to on
> failure and then make the task fail, it doesn't work. I
> created my own simple package and used the on failure and
> on success and they worked fine. This particular package
> imports 2 text files into a sql table and if those
> transformation tasks fail, I need it to send an email. As
> I said, it works on success, but not on failure. I've
> tried deleting one of the tasks so that only one runs and
> when it fails, the send mail task still doesn't execute.
> However on the simple package that I create, it works.
> Any thoughts?
> Thanks,
> Van|||It's definitely an issue with DTS. I created a new
package and simply copied the objects from the original to
the new package and now the send mail works on failure.
Strange that the original doesn't though. DTS has some
quirks and I believe this is one of them.
>--Original Message--
>Create a simple task in the package you are having
problems with and have it
>fire on failure in place of the email task. See if it
fires. If it does
>not, I would suggest it is a logic flow issue and not a
send mail issue.
>
>--
>Ata R
>Parvan Consulting Inc
>NO_SPAMar_alias001@.NO_SPAMparvan.net
>
>"Van Jones" <anonymous@.discussions.microsoft.com> wrote
in message
>news:011c01c3d473$dfbd5280$a101280a@.phx.gbl...
>> I'm having a problem with a DTS Send Mail task when it's
>> tied to an On Failure workflow task. I can change it to
>> on success and it works. But when I change it to on
>> failure and then make the task fail, it doesn't work. I
>> created my own simple package and used the on failure
and
>> on success and they worked fine. This particular
package
>> imports 2 text files into a sql table and if those
>> transformation tasks fail, I need it to send an email.
As
>> I said, it works on success, but not on failure. I've
>> tried deleting one of the tasks so that only one runs
and
>> when it fails, the send mail task still doesn't execute.
>> However on the simple package that I create, it works.
>> Any thoughts?
>> Thanks,
>> Van
>
>.
>|||In that case, are the package properties between the new and original
package the same?
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c3d54e$e742b5a0$a601280a@.phx.gbl...
> It's definitely an issue with DTS. I created a new
> package and simply copied the objects from the original to
> the new package and now the send mail works on failure.
> Strange that the original doesn't though. DTS has some
> quirks and I believe this is one of them.
> >--Original Message--
> >Create a simple task in the package you are having
> problems with and have it
> >fire on failure in place of the email task. See if it
> fires. If it does
> >not, I would suggest it is a logic flow issue and not a
> send mail issue.
> >
> >
> >--
> >Ata R
> >Parvan Consulting Inc
> >NO_SPAMar_alias001@.NO_SPAMparvan.net
> >
> >
> >"Van Jones" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:011c01c3d473$dfbd5280$a101280a@.phx.gbl...
> >> I'm having a problem with a DTS Send Mail task when it's
> >> tied to an On Failure workflow task. I can change it to
> >> on success and it works. But when I change it to on
> >> failure and then make the task fail, it doesn't work. I
> >> created my own simple package and used the on failure
> and
> >> on success and they worked fine. This particular
> package
> >> imports 2 text files into a sql table and if those
> >> transformation tasks fail, I need it to send an email.
> As
> >> I said, it works on success, but not on failure. I've
> >> tried deleting one of the tasks so that only one runs
> and
> >> when it fails, the send mail task still doesn't execute.
> >> However on the simple package that I create, it works.
> >> Any thoughts?
> >>
> >> Thanks,
> >>
> >> Van
> >
> >
> >.
> >
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment