Re: SQL mail and DTS package

#1

What I like to do is create a script to use CDONTS to mail me something.
This way you do not have to worry about a profile and things like that.
Just make sure that IIS is installed, and you are good to go.

Ozone
"LY" <lixiay (AT) hotmail (DOT) com> wrote

Quote:

I create a DTS package but the job will be running manually from account
admin's desktop, I want SQL to sent me a mail once they run the batch file

and call 'dtsrun /S sqlserver /E /N tableImport' from their workstation.
It is SQL 7.

Quote:

I installed MAPI client Outlook 2000 on the SQL server, configured the
profile.

I know how to use xp_sentmail, my question is how to implement this with
SQL mail xp_sentmail.

#2

In message <5619ACCE-0479-4614-8281-2308807050EA (AT) microsoft (DOT) com>, LY
<lixiay (AT) hotmail (DOT) com> writes

Quote:

I create a DTS package but the job will be running manually from
account admin's desktop, I want SQL to sent me a mail once they run the
batch file and call 'dtsrun /S sqlserver /E /N tableImport' from
their workstation. It is SQL 7.

I installed MAPI client Outlook 2000 on the SQL server, configured the
profile.

I know how to use xp_sentmail, my question is how to implement this
with SQL mail xp_sentmail.

Add a new Execute SQL Task to the start of your package that calls
xp_sendmail.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

#3

In message <euEsUd9$DHA.692 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Ozone
<rs_dovers (AT) yaho (DOT) com> writes

Quote:

What I like to do is create a script to use CDONTS to mail me something.
This way you do not have to worry about a profile and things like that.
Just make sure that IIS is installed, and you are good to go.

Ozone
"LY" <lixiay (AT) hotmail (DOT) com> wrote in message
news:5619ACCE-0479-4614-8281-2308807050EA (AT) microsoft (DOT) com...
I create a DTS package but the job will be running manually from account
admin's desktop, I want SQL to sent me a mail once they run the batch file
and call 'dtsrun /S sqlserver /E /N tableImport' from their workstation.
It is SQL 7.

I installed MAPI client Outlook 2000 on the SQL server, configured the
profile.

I know how to use xp_sentmail, my question is how to implement this with
SQL mail xp_sentmail.

If the profile is an issue then try xp_smtp_sendmail. I use it
exclusively over xp_sendmail.

If using a COM object then I much prefer JMail as there is no
dependencies, apart from the object itself of course.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

#4

Darren,I thought I configured the profile successfully, I
tested every step for the profile. But when I test the
xp_sendmail in QA, it is running forever, and it did not
reach recipient. I have to cancel it manually, does it
mean this is a problem with the Profile setup?
I have check 'Auto start SQL mail when SQL server started'
in the SQL Mail property, the only thing that I can think
of is that Outlook 2002 does not compatible with SQL
server7.

Quote:

-----Original Message-----
In message <5619ACCE-0479-4614-8281-
2308807050EA (AT) microsoft (DOT) com>, LY
lixiay (AT) hotmail (DOT) com> writes
I create a DTS package but the job will be running
manually from
account admin's desktop, I want SQL to sent me a mail
once they run the
batch file and call 'dtsrun /S sqlserver /E /N
tableImport' from
their workstation. It is SQL 7.

I installed MAPI client Outlook 2000 on the SQL server,
configured the
profile.

I know how to use xp_sentmail, my question is how to
implement this
with SQL mail xp_sentmail.

Add a new Execute SQL Task to the start of your package
that calls
xp_sendmail.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server
professionals
http://www.sqlpass.org

.

#5

In message <5c6d01c40072$d63ed410$a101280a (AT) phx (DOT) gbl>, LY
<lixiay (AT) hotmail (DOT) com> writes

Quote:

Darren,I thought I configured the profile successfully, I
tested every step for the profile. But when I test the
xp_sendmail in QA, it is running forever, and it did not
reach recipient. I have to cancel it manually, does it
mean this is a problem with the Profile setup?

Yes.

Quote:

I have check 'Auto start SQL mail when SQL server started'
in the SQL Mail property, the only thing that I can think
of is that Outlook 2002 does not compatible with SQL
server7.

Outlook 2002 is compatible (for Exchange at least), but the profile is
probably not configured correctly, such that if using Outlook you would
see a message box, but when using SQL Mail it just hangs on that message
box.

Some good SQL Mail resources-
http://support.microsoft.com/service.../wcblurb091301
..asp
http://support.microsoft.com/default...;en-us;Q281293
http://support.microsoft.com/default...;EN-US;Q263556

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL mail and DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SQL mail and DTS package - 03-01-2004 , 03:51 PM

Re: SQL mail and DTS package - 03-01-2004 , 03:51 PM

Re: SQL mail and DTS package - 03-01-2004 , 04:00 PM

Re: SQL mail and DTS package - 03-02-2004 , 10:24 AM

Re: SQL mail and DTS package - 03-04-2004 , 01:48 PM