Check if file exist in SSIS

Question

I want to check if file exist in SSIS, is it possible to do that without script task？

Answer 1

Hi @Jefferson-2765,

1. Add a ForEach Loop Container to your Control Flow.
2. On ForEach Collection pane, set Enumerator to "Foreach File Enumerator"
3. Set Folder to your Source Folder.
4. Set Files to your File Spec (.).
5. On Variable Mappings, create new variable "User::FileExistsFileName"
6. You then just need to configure two output Lines for the ForEach Loop:
7. For Success Line: Double-click the Connector Line, set:

Evaluation operation: Expression

Value: Success

Expression: @[User::FileExistsFileName] != ""

8. For Failure Line, set:

Evaluation operation: Expression or Constraint

Value: Failure

Expression: @[User::FileExistsFileName] == ""

Regards，

Zoe Hui

---

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