CODEWITHSUNDEEP
sql-serverssis
User7354632781
User7354632781

Reputation: 2264

How to send email from execute sql task?

How can i send email if execute sql task get executed and loads a table. so, if table is loaded with any record send email, if not loaded no email.

Appreciate any help.

Upvotes: 2

Views: 2451

Answers (2)

User7354632781
User7354632781

Reputation: 2264

its cool i solved it. i used two execute sql tasks and first one for loading data into the table, second one counting the records and i put variable on green arrow @MyVariable > 0 and connected the send mail task.

Thanks to all.

Upvotes: 0

SQLMenace
SQLMenace

Reputation: 134941

after that task add another task that checks if there are any rows in the table

something like

IF EXISTS (SELECT 1 FROM Yourtable)
BEGIN
 EXEC msdb.dbo.sp_send_dbmail ---------
END

read up on sp_send_dbmail here: http://msdn.microsoft.com/en-us/library/ms190307.aspx

Upvotes: 3

Related Questions