Sending a mail form an integration service package (SSIS) is implemented using the .Net framework classes.
The only question is how to use a SMTP Connection Manager task to configure the SMTP Server.
Public Sub Main()
Dim mailMessage As MailMessage
Dim smtpClient As SmtpClient
Dim smtpConnectionString As String = DirectCast(Dts.Connections("SMTP Connection Manager").AcquireConnection(Dts.Transaction), String)
Dim smtpServer As String = smtpConnectionString.Split(New Char() {"="c, ";"c})(1)
mailMessage = New MailMessage("from@myMail.net", "to@myMail.net")
mailMessage.Body = "myMessage"
mailMessage.Subject = "mySubject"
smtpClient = New SmtpClient(smtpServer)
smtpClient.Credentials = CredentialCache.DefaultNetworkCredentials
mailMessage.IsBodyHtml = True
smtpClient.Send(mailMessage)
Dts.TaskResult = Dts.Results.Success
End Sub
2 comments:
Hi
how can i send current package log file as email attachment
Hi Harnath,
The following code alows you to send a file as attachment:
mailMessage.Attachments.Add(New Attachment("D:\ssis.log"))
mailMessage.Attachments(0).ContentDisposition.DispositionType = "attachment"
mailMessage.Attachments(0).ContentDisposition.FileName = "ssis.log"
The ssis.log is the SSIS log file.
Post a Comment