How to resolve when Package failed in this scenario?

Question

I have 10 excel sheets in the folder. I want to loop all these by using ForEachLoop Container.

Package failed after loading data from first 4 excel sheets and I need to load remaining 6.

How can I load data of remaining 6 excel sheets only into tables?

Answer 1

Hi @Ramana Kopparapu

You may follow this article which gives the detailed steps.

Continue a Foreach loop after an error in a SQL Server Integration Services package

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.