send email task in ssis

Question

Hi Team,

I need to send the email notification hyperlink through ssis, once user click that link microsoft excel need to open. Can you please help me to handle this task in ssis.

Thanks,

CMK

Answer 1

email ... hyperlink ... ssis ... user click ... excel

What's that for a strange mix of different technics/terms/apps/etc????

please help me to handle this task in ssis.

In SSIS? Close to impossible, SSIS packages aren't event driven. You have to implement your own solution and that means a lot of work.

Answer 2

Hi @cmk

You may use send email task or Script Task to do that.

Check below links for details.

https://www.sqlatelier.com/2022/01/ssis-send-email-hyperlink-with-space.html

https://stackoverflow.com/questions/68806763/ssis-send-mail-task-hyperlink-rename

https://www.tutorialgateway.org/script-task-in-ssis/

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.