if the file is not available in path -SSIS

Shambhu Rai 1,406 Reputation points
2022-04-11T15:47:00.687+00:00

Hi Expert,

there is excel file source and file path is provided . Any day if the file has not come then package should not fail and to be completed..it should give notification email

191952-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,483 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,255 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,576 Reputation points
    2022-04-12T01:07:54.02+00:00

    Hi @Shambhu Rai .

    Let me double check that what you want to do is if the file is not exist, send the e-mail.

    You may use script task to first check the file existence and then drag Send email task and connect to Script Task.

    Here is a detail tutorial you may take a reference to.

    send-email-on-when-file-not-found-for-flat-file-connection

    ssis-how-to-check-if-file-exists-in.html

    You may also use Foreach Loop Container to check the existence and then define a variable.

    steps-to-check-if-a-file-exist-or-not

    PS: You have post several issues on Q&A, if these issues have been resolved, you could mark it as answer, it will also encourage us to offer more help.

    Regards´╝î

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.