How to quit SSIS without erroring

Christopher Jack 1,611 Reputation points
2021-03-12T08:42:56.877+00:00

Hi,

Just a wee question.

I have a SSIS package which reads an excel sheet into the database from a folder. If
there is no excel file there, how do I exit the SSIS package without failing the job?

What would I point the red arrow to? and would that exit the package?

Thanks... still learning .

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-15T03:17:10.59+00:00

    Hi @Christopher Jack ,

    1.We should edit the Excel Connection Manager correctly and preview excel data in Excel Source.

    2.Rather than permitting the component to fail, you can configure the component to redirect the failed row to another processing path, by using the error output.
    Please refer to Lesson 4-3: Add error flow redirection and An overview of Error Handling in SSIS packages.

    Best regards,
    Mona

    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.