Two Mail at a Time through Script Task

Question

Two Mail at a Time through Script Task

sqlusers

SSCrazy

Points: 2463
More actions
April 7, 2010 at 1:05 am

#213491

Hi,
Is it possible to send two separate mail (Successful Mail and Non-matching records) through Script Task at a time in SSIS?
--

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I am having trouble understanding what exactly your question is. Could you explain what your problem is and not necesarrily your proposed solution.

CEWII

COZYROC One Orange Chip Points: 28499 More actions · Answer 2

sqlusers (4/7/2010)
Hi,
Is it possible to send two separate mail (Successful Mail and Non-matching records) through Script Task at a time in SSIS?
--

Why not use the standard Send Mail Task? You can setup conditional workflow based on expression and have one branch execute for first case and another branch for the second case.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

In a Script Task you are essentially writing code. So if you write code to send one email you can just write more code to send another. That being said I would also defer to the Send Mail Task unless there are compelling reasons not to do so.