Before processing the file, you have to validate the file is today's date or not. If the file is today's date then we have to process the file or else we need to reject the file and send an email notofication in SSIS

Question

Before processing the file, you have to validate the file is today's date or not. If the file is today's date then we have to process the file or else we need to reject the file and send an email notofication in SSIS

Answer 1

Hi @durga prasad bandarla ,

Welcome to Microsoft Q&A!

Sorry, I am not clearly with your question. Are you mean processing files by creation time or evaluate inside time in a file? If you mean processing of files by file creation time, please refer to this blog. If it's another hypothesis, you could access your system variables. System::StartTime will be when the package started execution. If there is a significant amount of time between start of execution and the element that needs to evaluate the current time, you can look at the ContainerStartTime. For more information, please refer to this thread.

After the validation, you could send emails via Send Mail Task. For more information, please refer to Send Mail Task and Sending email from SQL Server Integration Services.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.