SSIS - Send Mail Task

Question

Hello,

I created an SSIS ETL that Loops through a local folder, inserts excel file data into a SQL db, then archives the file. I'm trying to add a Send Mail Task to the process but I can't seem to get it to work. I can get the email to run but it seems to break my Archive process.

I really need help showing where to place the SMT process in the ETL. Here is copy of the SSIS workflow:

Control Flow:

Dataflow:

Any help would be greatly appreciated.

Thanks,

Tim

Answer 1

Hi Mona,

I was placing right before the Archive Files process.

I believe setting delayed validation to True in properties resolved my issue.

Regards,

Tim

Answer 2

Hi Tim,

May I know where do you use Send Mail Task in your Control Flow?

Could you please share the error messages when executing the ssis package with Send Mail Task?

Best Regards,
Mona

---

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