Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

Question

Post reply

Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

Manish Sinha

Ten Centuries

Points: 1023
More actions
May 6, 2009 at 12:05 am

#208970

Comments posted to this topic are about the item Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

Viewing 15 posts - 1 through 15 (of 41 total)

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

James Gregg-185793 SSC Enthusiast Points: 117 More actions · Answer 1

Manish..please repost the images as they are not displayed in the article.

:hehe:

dave.farmer SSCrazy Points: 2431 More actions · Answer 2

Can I second that request - the article is very useful but I'm trying to use this idea to create a more generic mail solution I can use for alerts on my data loading and without the images it's just too much guesswork (I could work it out with a bit of time, but time is very limited here at work! :ermm:).

hariomhari SSC Journeyman Points: 80 More actions · Answer 3

wonderful article, but handicapped without the images 🙁

please post the images

Adrian Charles Chetwynd-Talbot SSC Enthusiast Points: 178 More actions · Answer 4

The article is missing all its screenshots, would it be possible to republish the page again

BCC-493036 Mr or Mrs. 500 Points: 555 More actions · Answer 5

I'm interested in this article, but where are all of the screenshots? Those images will help the readers to understand what you were talking about. Could you please repost the screenshots?

--------------------------------------------------------------
DBA or SQL Programmer? Who Knows. :unsure:

Lempster SSCoach Points: 15651 More actions · Answer 6

Useful article, but I think it is easier to use the Send Mail task with Expressions to dynamically set properties such as MessageSource, To, From, Subject etc.

Peter Rijs Hall of Fame Points: 3400 More actions · Answer 7

As stated this might have been an interesting article when it was complete.

However: apart from the missing images I read no arguments in his article to come to the conclusion that a script task is simpler to send mail from SSIS than the Send Mail task. To me the conclusion is therefore no more then an opinion.

To come to that conclusion I would like to see the stated (more complex) functionality, with an implementation both using a script task and using the sendmail task. Only then it could be pointed out what the simpler and more flexible way is to do so.

That might also stimulate a discussion about the used techniques, in which optimizations and best practices might be developed/shared.

Peter Rijs
BI Consultant, The Netherlands

dnamccauley Valued Member Points: 55 More actions · Answer 8

I have a question - if I send mail this way, is it easier to track when the mail was sent & to whom? And last, any way to see an actual copy of the email being sent?

THanks!

drwhitaker SSC-Addicted Points: 434 More actions · Answer 9

Cannot see all the images and information. Please re-post;-)

Manish Sinha Ten Centuries Points: 1023 More actions · Answer 10

Yes. while sending mail, you can store sent datetime and To address in database or log it in a text file using variables used for these field values.

Manish Sinha Ten Centuries Points: 1023 More actions · Answer 11

I posted the images also with the article.

What should I do now? Shall I post the article again to contribution center.

michael hickman Grasshopper Points: 21 More actions · Answer 12

with out the images, your article doesn't hold water.

Please repost, with pics.

Thanks

Brett Flippin Right there with Babe Points: 717 More actions · Answer 13

I agree with the earlier post saying this is MUCH more easily done with a Send Mail task and expressions. You're doing nothing but replicating functionality already built into Send Mail task.

I'd say the simplest and easiest way to do something would be to take advantage of the tools given instead of reinventing the wheel.

Sasidhar Chavali Newbie Points: 3 More actions · Answer 14

Without images it is not very helpful, please repost them.