Some of the data your company processes is sent in from partners via email. How would you configure an SMTP connection manager to extract files from email messages?

Question

Options

• AIn the SMTP connection manager, configure the OperationMode setting to Send And
• BIt is not possible to use the SMTP connection manager in this way, because it can only be
• CThe SMTP connection manager supports sending and receiving email messages by default,
• DIt is not possible to use the SMTP connection manager for this; use the IMAP (Internet

• B
  95% (19)
• D
  5% (1)

Explanation

The SMTP (Simple Mail Transfer Protocol) connection manager in SSIS is designed exclusively for sending outbound email messages. SMTP is a one-way, send-only protocol by design - it cannot receive, retrieve, or read incoming email messages or extract attachments. To receive email and extract files from messages sent by partners, you would need a different protocol such as IMAP or POP3. Since no native IMAP or POP3 connection manager exists in SSIS, you would need a Script Task with custom code or a third-party component. Option B is correct because the SMTP connection manager simply cannot be configured for receiving mail.

No community discussion yet for this question.