I have developed a SSIS package.
Source : XLSX File
Destination : SQL Server Table
The XLSX files contains 4 tabs. I am loading 4 tabs into 4 different tables by creating 4 data flows.
inside For each loop container
1. Used Script Component
i have checked whether the given file is valid or not. if valid, it executes the step 2. if not valid, it send out an email
2. Used 4 Dataflows one for each tab. All are independent data flows
please find the strucure attached:
If any one of the tabs get failed, it should not load the other three tabs.
Please advise how to proceed.