This project is read-only.
1
Vote

When remote Filter is given- Task is not failing even if no match found. Why? How can we fail it then

description

In SSIS Extension : SFTP Task, I noticed something really weird. When I was using it in 'Receive File(s)' mode, if I don't specify 'Remote Filter' and provide full file path on 'Remote File' then the task is correctly failing as and when the file is not present in SFTP. But on the other hand, while I'm specifying any Remote Filter, then it is actually working for right files in some case when no file is available in SFTP then also task is turning Green.

Any help? We ideally want it to fail when there is no matching file available right?

comments