question

ChristopherJack-1763 avatar image
0 Votes"
ChristopherJack-1763 asked Monalv-msft edited

How to quit SSIS without erroring

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @ChristopherJack-1763 ,

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChristopherJack-1763 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·