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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Manish Sinha » Sending Mail In SSIS Using Script Task-...

43 posts, Page 1 of 5

1 2 3 4 5 »»»

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

Rate Topic

Display Mode

Topic Options

Author

Message

Manish Sinha

Posted Wednesday, May 06, 2009 12:05 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 05, 2010 10:47 PM
Points: 93, Visits: 98

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

Post #710831

James Gregg-185793

Posted Wednesday, May 06, 2009 12:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, July 21, 2012 12:05 PM
Points: 5, Visits: 90

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

Post #710833

dave.farmer

Posted Wednesday, May 06, 2009 3:06 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:39 AM
Points: 857, Visits: 584

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

Post #710889

hariomhari

Posted Wednesday, May 06, 2009 5:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 28, 2012 8:27 AM
Points: 2, Visits: 25

wonderful article, but handicapped without the images :-(

please post the images

Post #710955

Adrian Charles Chetwynd-Talbot...

Posted Wednesday, May 06, 2009 6:07 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 10, 2010 5:12 AM
Points: 36, Visits: 31

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

Post #710973

BCC-493036

Posted Wednesday, May 06, 2009 6:13 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 8:36 AM
Points: 27, Visits: 282

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

Post #710977

Lempster

Posted Wednesday, May 06, 2009 6:19 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 1,448, Visits: 755

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.

Post #710986

Peter Rijs

Posted Wednesday, May 06, 2009 6:28 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, April 25, 2013 6:03 AM
Points: 856, Visits: 573

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
MCITP BI Dev & DB Dev (SQL 2008 & 2005)

Post #710994

dnamccauley

Posted Wednesday, May 06, 2009 7:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 08, 2009 1:50 PM
Points: 1, Visits: 2

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!

Post #711054

drwhitaker

Posted Wednesday, May 06, 2009 7:36 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 2:07 PM
Points: 16, Visits: 85

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

Post #711058

« Prev Topic | Next Topic »

43 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions