SendMailMessageSourceType Enumeración

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Tasks.SendMailTask

Ensamblado:

Microsoft.SqlServer.SendMailTask.dll

Especifica el tipo de la propiedad MessageSource, que contiene o señala al cuerpo del mensaje de correo electrónico.

public enum class SendMailMessageSourceType

public enum SendMailMessageSourceType

type SendMailMessageSourceType = 

Public Enum SendMailMessageSourceType

Herencia

Enum

SendMailMessageSourceType

Campos

DirectInput	0	Especifica que el origen del mensaje está contenido como texto en la propiedad MessageSource.
FileConnection	1	Especifica que el origen del mensaje está contenido en el archivo cuyo nombre se establece en la propiedad MessageSource.
Variable	2	Especifica que el origen del mensaje está contenido en la variable cuyo nombre se establece en la propiedad MessageSource.

Ejemplos

En el ejemplo de código siguiente se crea un nuevo SendMailTask que usa la SendMailMessageSourceType enumeración .

using Microsoft.SqlServer.Dts.Runtime;  
using Microsoft.SqlServer.Dts.Tasks.SendMailTask;  

class Program  
{  
  static void Main(string[] args)  
  {  
    Package pkg = new Package();  
    ConnectionManager smtpCM;  
    smtpCM = pkg.Connections.Add("SMTP");  
    smtpCM.Name = "SMTP Connection Manager";  
    smtpCM.ConnectionString = "smtphost";  
    Executable exe = pkg.Executables.Add("STOCK:SendMailTask");  
    TaskHost thSendMailTask = ((TaskHost)(exe));  
    thSendMailTask.Properties["SmtpConnection"].SetValue(thSendMailTask, "SMTP Connection Manager");  
    thSendMailTask.Properties["ToLine"].SetValue(thSendMailTask, "someone1@example.com");  
    thSendMailTask.Properties["CCLine"].SetValue(thSendMailTask, "someone2@example.com");  
    thSendMailTask.Properties["BCCLine"].SetValue(thSendMailTask, "someone3@example.com");  
    thSendMailTask.Properties["FromLine"].SetValue(thSendMailTask, "someone4@example.com");  
    thSendMailTask.Properties["Priority"].SetValue(thSendMailTask, MailPriority.Normal);  
    thSendMailTask.Properties["FileAttachments"].SetValue(thSendMailTask, "C:\\test_image.jpg");  
    thSendMailTask.Properties["Subject"].SetValue(thSendMailTask, "Testing the SendMail Task");  
    thSendMailTask.Properties["MessageSourceType"].SetValue(thSendMailTask, SendMailMessageSourceType.DirectInput);  
    thSendMailTask.Properties["MessageSource"].SetValue(thSendMailTask, "This is only a test.");  
    DTSExecResult valResults = pkg.Validate(pkg.Connections, pkg.Variables, null, null);  
    if (valResults == DTSExecResult.Success)  
    {  
      pkg.Execute();  
    }  
  }  
}  

Imports Microsoft.SqlServer.Dts.Runtime  
Imports Microsoft.SqlServer.Dts.Tasks.SendMailTask  

Module TestSendMailTask  

  Sub Main()  

    Dim pkg As New Package  

    Dim smtpCM As ConnectionManager  
    smtpCM = pkg.Connections.Add("SMTP")  
    smtpCM.Name = "SMTP Connection Manager"  
    smtpCM.ConnectionString = "smtphost"  

    Dim exe As Executable = pkg.Executables.Add("STOCK:SendMailTask")  
    Dim thSendMailTask As TaskHost = CType(exe, TaskHost)  
    With thSendMailTask  
      .Properties("SmtpConnection").SetValue(thSendMailTask, "SMTP Connection Manager")  
      .Properties("ToLine").SetValue(thSendMailTask, "someone1@example.com")  
      .Properties("CCLine").SetValue(thSendMailTask, "someone2@example.com")  
      .Properties("BCCLine").SetValue(thSendMailTask, "someone3@example.com")  
      .Properties("FromLine").SetValue(thSendMailTask, "someone4@example.com")  
      .Properties("Priority").SetValue(thSendMailTask, MailPriority.Normal)  
      .Properties("FileAttachments").SetValue(thSendMailTask, "C:\test_image.jpg")  
      .Properties("Subject").SetValue(thSendMailTask, "Testing the SendMail Task")  
      .Properties("MessageSourceType").SetValue(thSendMailTask, SendMailMessageSourceType.DirectInput)  
      .Properties("MessageSource").SetValue(thSendMailTask, "This is only a test.")  
    End With  

    Dim valResults As DTSExecResult = pkg.Validate(pkg.Connections, pkg.Variables, Nothing, Nothing)  

    If valResults = DTSExecResult.Success Then  
      pkg.Execute()  
    End If  

  End Sub  

End Module