.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Email Notification in SSIS

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

Can anyone please provide a good link on 'Sending Email Notification in SSIS' in HTML format.


View Complete Post

More Related Resource Links

email notification error 5.1.1


 I am getting an error when sending email via asp.net.  The error is "Mailbox unavailable. The server response was: 5.1.1...User unknown."

However, the email is getting sent.  Why is asp.net returning this error?

I'm using VS 2008, vb.net,  running 2.0 framework.  This happens regardless of whether I'm testing my application from my local machine or running production version.  Also, I can send a batch of emails and get the error for some but not all.

I would like to be able to count of the error messages really being accurate, so this situation is unhelpful to our users, because they will start to just ignore all error messages.




notification email not sent when updating a task programmatically

I have a task that's in the task list and has no value in the Assigned To field. When I update the field like this: listItem[SPBuiltInFieldId.AssignedTo] = SPContext.Current.Web.CurrentUser.ID; ListItem.Update(); The task is updated (the assigned to has filled in). But no notification has been send to the person in the assigned to. But when I change the assigned to manualy to another person, and then again to the person it was before, the notification is send. So the email works and the notifications are activated, why is there no notification sent when I change the assigned to programmatically?

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3

Site FAQ: Email Notification Settings

There are several settings that come into play with email notifications coming from the ASP.NET forums:Edit Profile (http://forums.asp.net/user/EditProfile.aspx)1. Receive Emails: [ ] Yes  [ ] No - This is the master email switch. Setting this to [ ] No will prevent ALL forums-related emails from being sent to you, including password reset emails (if you find yourself in that situation, please use the site's Contact form to request password reset assistance).  Setting this back to [ ] Yes will allow emails to once again be sent to you.  This setting could be handy if you will be away from the ASP.NET Forums for a while and are not interested in receiving emails from the site while you are away.2. Receive rich (HTML) emails [ ] Yes [ ] No - This affects only the format in which emails are sent.  It has no bearing on whether or not emails are sent.  If [ ] No is chosen, the email will be sent in plain text.3. Enable Email Notifications of forum/thread subscriptions and replies to my posts. [ ] Yes  [ ] No - This is the default value of thread subscriptions. This value is checked only at the time of your first post to a thread, and the thread subscription is set to this value. Changing this value has no effect on any existing thread subscriptions. To discontinue (or start) receiving email notifications for a particular thread, see #5 below.&n

Sharepoint 2010 WorkFlow Task AssignedTo Windows Group doesnt send email notification

Hi, Which configuration would prevent sharepoint to send a notification when a workFlow task is assigned to a Windows Group with an email ? The same task with a single User send a notification. Thanks, Patrice      

How to generate an excel and send it as email attachment in SSIS 2005 Script Task Component?


I am using a "Script Task" component. I am trying with following three simple steps:

1) Obtain the excel content in HTML

Dim reportInHtml As String = GenerateHTMLReport()

2) Generate an excel with below code:

Dim message As MailMessage

message = New MailMessage(fromAddress, toAddress, subject, String.Empty)

Using memoryStream As MemoryStream = New MemoryStream()

        Dim contentAsBytes As Byte() = Encoding.UTF8.GetBytes(reportInHtml)
        memoryStream.Write(contentAsBytes, 0, contentAsBytes.Length)
        memoryStream.Seek(0, SeekOrigin.Begin)

        Dim contentType As ContentType = New ContentType()
        contentType.MediaType = "application/ms-excel"
        contentType.Name = "Excel_Report.xls"

        Dim excelAttachment

Sending Email to a distribution list having more than one member through SSIS

Our mail box team created one group email address (


),they have added 10 users(10 email addresses) to this group.

When i am sending email to this group


through send mail task in ssis package was executed successfully but it didn't send the email to the members of the group.Looks bad.
What might be the reason ?

Let me know if you have any questions.

I appreciate your help. Thanks

email notification


I have a document library with Content Approval value set to “Yes”.

When contributor clicks a "submit for approval" button, I would like send an email out to approvers automatically. I can setup a workflow to do it. But would like to find if there is OOTB function I can enable at document library level so it will send out email notification without any build customized workflow process.





Removing standard text from custom feedback process email notification


My workflow has a Start Feedback Process action, which contains some pre-defined instructions. One of my instructions is to use a particular link to open the workflow history page – I have added this to force the user to open the form via the workflow history page (we're using Forms Services) because the email’s default link opens the form in the InfoPath client, not the browser. It also allows the user to be returned to the page where they will complete their workflow task (we're trying to make navigation as easy for them as possible).

Although I have defined my own set of instructions, the email notification I receive includes some standard text that links to the InfoPath form’s xml file. I don’t want users inadvertently clicking the “To complete this task…” link at the bottom of the email and having the form open in InfoPath. Here is an example of the email I’m referring to:


SSIS Expression to send email with dataset on the Mail Subject line.



I have a task - I need to email total number of products sold on the subject line of the mail task.

I have Execute SQL task process like select count(*) from tablename. Then I need to Mail the result set like "Total products sold September 2010 : 15000" on teh subject line.

I created a variable bit i dont know how to assign it on the subject line of the Send Mail Task.

I would really appreciate if you can guide me.

Thanks for your help.


Email Notification Field when uploading documents?


Hi All,

I am in the modist of rolling of SharePoint2010 pilot phase to internal users in my organization, I would like to hear from the experts on the following.

While trying to cerate a re-usable workflow in SharePoint Designer 2010, I am using the default action of "To-Do Task" , the issue here is in the out-of-the-box it sates that I got to hard-code the users whom I want to send this email, but I would like users to choose whom they would like to notify rather than hard-coding.

Any advice?

email alert notification when task status column value is chaned


Hi All,

I am creating a document library in which there are few columns present (like Assigned To,Task Status,Reviewr etc.)

I want to send alert or email notification when the status value is changed. Alert should go to "Assigned To" selected value from the Reveiwers name.

I have tried this with "alert me" functionality provided by WSS 2007 but I think it will not sufficient for me?.

I am not able to proceed please help me?

Email Notification on Discussion Board


how is it possible to setup a Discussion Board in which the person that initially started the discussion is notified automatically when someone responds to his/her discussion?

The first issue here is, that I don't see an option to have an automatic Email notification setup for a user. I think SharePoint only provides a method to let users setup their Notifications. I need something, so that for the user which started the discussion the Email notification is setup automatically.

The second problem I have with Email notifications is, that if a user creates a notification rule that says notify me, as soon as someone else changes an item created by me, that by SharePoint responses are not recognized as "changes".

How can I solve these issues? Are there third-party tools that might provide a solution?

Empty field on Alert Notification email sent to user when they add an 'Alert Me'




I'm trying to figure out the empty field that should be populated in the email that a user receives when adding an alert. The missing field is the bit in single quotes that is blank. I have added a link to a screenshot below as well.

What is the source of this field? Any ideas why it is blank?


thanks in advance.


Alert 'xxx' has successfully been added on '' .

You will receive alerts in e-mail. The timing and criteria for the alerts depend on the settings entered when the alert was added.

You can change this alert or any of your other alerts on the My Alerts on this Site page.



Email alert is created but i didn`t received any notification when an item changes

I received an email alert when an alert is created.but i didn`t received any email notification when an item changes.??can any one please help me with this..?

Why wss 3.0 backup site throwing email notification for completed task




We have taken backup and restore site in different box with all document and workflow (including workflow status) using STSADM.


Now the new backed up site is sending email notification for completed task from new box where task status is showing as completed.


Is it something that we also need to take backup of workflow runtime also? Not sure


Please advice.

Regards Sudip Misra sudipmisra@hotmail.com +91-9916768623 Bangalore

Email Notification for Workflow approvers



MOSS 2007

I have a issue with workflow (out of box) email alerts. We get the email alert for a workflow intiator but not for an approver

Due date alerts are working fine, only the job immediate alerts are not coming,

When approver is trying to reassign the task to some person, even he dont receive any email for his new task.

pls suggest me on this issue.

all the settings are fine,

thanks for the help.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend