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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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
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.