Receiving File error when the file does not exist in the SFTP task

[joseph...@gmail.com]

Hi 

Am new to in ssis and cozyroc tools ,now i am working with SFTP Task , its working fine when my remote folder have file and does not work when doesn't have file .

So how can check whether file exist or not. 

Thanks in advance

Shiju 

 

[Ivan Peev]

Hi Shiju,

By default the SFTP Task will fail if you specify remote location without files. You can override this behavior by setting NoRemoteFilesFail parameter to False. In this case, if a file is not found the task will not fail.

Ivan

[joseph...@gmail.com]

Hi Ivan,

Thanks for your immediate reply .Now its working fine .

The one more scenario am facing like , Every time am sending email which mentioned the status of SFTP task ,when the downloaded complete the status -success and it doesn't have file i need to update the status like file does not exist.

How can i identify the both scenario.

Thanks 

Shiju  

[Ivan Peev]

Shiju,

In this case you have to set NoRemoteFilesFail = True again and setup the task not the fail the package execution. Then you have to setup a failure constraint on the SFTP Task and attach a task which sends an email notifying the file doesn't exist.

Ivan

[joseph...@gmail.com]

Hi Ivan,

Thanks for your valuable reply and its working fine.

Is there any option for check in the SFTP for whether any file exist or not ?

In SFTP task there is one action like "Get Remote File List ",using this option any choices to check whether file exist or not in the ftp.

Thanks 

Shiju 

[Ivan Peev]

Hi Shiju,

You can use the reusable script task here to check for FTP file existence. The script has to be used with COZYROC's Script Task Plus.

[mohdrafi...@gmail.com]

Hi Peev,

if i have to track any of the Errors if SFTP failed due to any of the reasons how can we  track that

Rafiq

[Ivan Peev]

Hi Rafiq,

Please next time do not hi-jack existing unrelated discussions, but create a new discussion.

Regarding your question, you can setup a failure constraint and handle the error situation as you please.

[asif....@gmail.com]

I had the same problem and your solution worked for me.

Thanks :)
Asif