Multiple choice technology databases

It is not Possible to Send Mail directly From SSIS Packages using

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SSIS packages can send emails directly using the Send Mail Task. The statement claims it is not possible, which is false. Send Mail Task is a standard control flow task in SSIS.

AI explanation

False. Even though the sentence is cut off after 'using', the claim being tested is whether SSIS can send mail directly. It can: SQL Server Integration Services ships a built-in Send Mail Task in the control flow that sends email directly from the package via an SMTP Connection Manager (with Direct Input, File, or Variable as the message source, and support for attachments). Because SSIS natively supports sending mail directly (through the Send Mail Task, and additionally via a Script Task), the assertion 'It is not possible to send mail directly from SSIS packages' is FALSE. The marked answer (False) is correct.

Keep practicing — related questions