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

durga prasad bandarla 1 Reputation point
2021-09-20T08:54:20.783+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,490 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-09-21T03:10:12.45+00:00

    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.

    0 comments No comments