SendMailMessageSourceType 열거형

정의

네임스페이스:

Microsoft.SqlServer.Dts.Tasks.SendMailTask

어셈블리:

Microsoft.SqlServer.SendMailTask.dll

이메일 메시지 본문을 포함하거나 가리키는 속성의 MessageSource 유형을 지정합니다.

public enum class SendMailMessageSourceType

public enum SendMailMessageSourceType

type SendMailMessageSourceType = 

Public Enum SendMailMessageSourceType

상속

Enum

SendMailMessageSourceType

필드

Name	값	Description
DirectInput	0	메시지 소스가 속성 내에 MessageSource 텍스트로 포함되어야 함을 명시합니다.
FileConnection	1	메시지 소스가 속성에 명 MessageSource 시된 파일에 포함되어야 함을 명시합니다.
Variable	2	메시지 소스가 속성에 MessageSource 명시된 변수 안에 포함되어야 함을 지정합니다.

예제

다음 코드 샘플은 열 SendMailMessageSourceType 거를 사용하는 새로운 SendMailTask 코드를 생성합니다.

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