dts & mail

hi guys...

how is do for when finished dts ,sending mail by sql server..also i am using sql server 2000...

can i do ?

thanx,,,

Try asking this in the DTS forum: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

This is for SQL Server Integration Services on SQL Server 2005

DTS - SQL Server Agent Mail Issue

Hi,

Wondering if anyone there can tell me what I'm doing wrong (and please be gentle as I'm not at all techy).

I have a DTS scheduled on the Server Agent to run, and at the end it is to send a mail to notify me and several others that it has completed. Trouble is, it runs but doesn't send the mail.

However if I execute the DTS manually it does send the mail.

I have a idea it might be to do with the Profile in SQL Mail in Server Settings on the Properties of the server, but have no idea how to correct this.
Can anybody help?Check out MS KBs:

311231
315886
263556

Regards,

hmscott|||Cheers, will have a look now.

DTS - Send Mail problem

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
> >
> >
> >.
> >

DTS - On Failure send mail does not work

Hi

Task A is a Execute Package task, and Task B is as Send Mail task. They are connected with a 'On Failure' connection.

The problem is that when task A fails, task B is not run. Why?

I have enabled and disabled the 'Fail package on step failure' for task A and it's 'child' in every way possible. I allowed transactions, and then tried again with them of...

Suggestions?

Thanks in advance.
__________________
Joo MartoHave you verified that the event is in fact failing ? Create an on success flow with the same step and see what happens.|||With on success it works... but the log status of the task is failled!

How can that be?|||does this happen when ur failure step is the mail task? or it doesnt matter?|||Check if you have On Success report Failure.|||Try making Task B an activeX script or sumthin else and c if that works...

also check in ur execute package task when the package fails ie, how many steps in the package need to fail for the package task to fail...i think the default is 4 steps but u shud check what it is for ur package|||Busy day - sorry for the delay. Modify the package's property to "fail package on first error" - I am referring to the package that you are executing in execute package.|||Originally posted by rnealejr
Busy day - sorry for the delay. Modify the package's property to "fail package on first error" - I am referring to the package that you are executing in execute package.

Thankyou very, very, much