ssis - how to check file exists

Question

I have to import 3 excels into database, my input path is variable. how can I check files exists, if don't exists, then it will not process the import task, and go end task. if file exists, then go import file task.

Answer 1

Hi @nononame2021 ,

Check it out here: steps-to-check-if-a-file-exist-or-not

Answer 2

Hi @nononame2021 ,

Thanks for your question.

Please refer to below steps:

...  
using System.IO;  
...  
Dts.Variables["Exists"].Value = File.Exists(Dts.Variables["FilePath"].Value.ToString());  
            MessageBox.Show(Dts.Variables["FilePath"].Value.ToString());  
            MessageBox.Show(Dts.Variables["Exists"].Value.ToString());  

For more information, please refer to this vedio.

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 3

how to go end flow if file not exists.