How to Handle Failed Process Task in SSIS

Vijay Kashyap Algo Trading Expert

1. Copy FTP files to Local Folder

2. Move that file to Error Folder

3. Send Email









Step 1: We need to configure process task property so even process task failed  or success we should not fail the packge.






Step 2:  bring foreach loop task to check , if process task has copy the file in local fodler from ftp. Foreach loop will be able to read through that location.





and also , we have to map the variable so foreach loop will copy the path of file into variable.


step 3: Set the expressoin for constraint 







Step 4: this will move the file to error folder.




Result : In case of sucess. 



In case of failure or not found path by process task.