I am trying to use "Send Mail" task in SQL SSIS, but it keeps giving me an error:
SSIS package "Package1.dtsx" starting.
Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "The remote certificate is invalid according to the validation procedure.".
Task failed: Send Mail Task
SSIS package "Package1.dtsx" finished: Success.
My settings are to use SSL and Windows Authentication.
If I uncheck both, and configure my Exchange distribution group to not require "authenticated" users only, it works but this is not ideal we would like to use SSL.
Is there anyway to fix this?