ssis to check file exists at begin stage

Question

how can I define a variable to check the 2 excels files exists at beginning of ssid, if false , then return error, if exists , then go to green path to continue.

the path folder as below:
C:/SSIS

check 2 files:
input1.xls
input2.xls

variable: isFilesExists (boolean type)

any ssis set up for reference

Answer 1

Hi @nononono ,

We can use Foreach Loop Container to check if the excel file exist.

Then set the Precedence Constraints between Foreach Loop Container and the next task.

Please refer to the following pictures:

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.