Emailing within DTS package

#1

I need to create a DTS package that sends out an email based on a query.

Query:

Code:

SELECT @Count= count(*) FROM employee WHERE site = 1

If @Count=0 I don't want an email to be sent. If @Count>=1 then the email
should be sent out.

How do I set up the package to reflect this?

Thanks,
Ninel

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200607/1

#2

Hello ngorbunov,

Quote:

I need to create a DTS package that sends out an email based on a
query.

Query:

Code:

SELECT @Count= count(*) FROM employee WHERE site = 1

If @Count=0 I don't want an email to be sent. If @Count>=1 then the
email should be sent out.

How do I set up the package to reflect this?

Thanks,
Ninel

take a look at this post.
Bye

Davide

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

Emailing within DTS package

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

Emailing within DTS package - 07-11-2006 , 02:32 PM

Re: Emailing within DTS package - 07-12-2006 , 01:55 AM