How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-taskIf you are not sure there will be files on the remote server
when you execute the package and you do not want the package to fail in that situation, then set the NoFilesFail parameter to "False". If
you are converting your packages over from using the deprecated SFTP Task, then
be aware that this is a new parameter. With the SFTP Task, setting the StopOnFailure parameter to "False" would accomplish the same
thing. The following table makes it clear how these two parameters are used with
the File Transfer Task.
NoFilesFail | StopOnFailure | Result |
True | False | Task will fail if there is no file. Task will not fail for any other errors related to the operations it’s performing. |
False | False | Task will not fail if there is no file. Task will not fail for any other errors related to the operations it’s performing. |
True | True | Task will fail if there is no file. Task will fail for any other errors related to the operations it’s performing. |
False | True | Task will not fail if there is no file. Task will fail for any other errors related to the operations it’s performing. |
The NoFilesFail Property can be found by right clicking the File Transfer Task --> Choose Properties --> Under Misc grouping set 'NoFilesFail' = 'False'
The File "" doesn't contain file path(s). See ticket 11056
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist.
Action: When executing an SSIS package with the File Transfer Task, the following error is encountered. Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist. ...Can I use the Flat File Connection Manager with the File Transfer Task?
The Flat File Connection Manager can be used with the File Transfer Task for the Local parameter when the Action is Send Files. However, it cannot be used when the Action is Receive Files. In that case, a File Connection Manager should be used. If ...Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.'
Action: When configuring a package using the File Transfer Task, the following error is encountered. Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.' Solutions: This ...How to structure a package using File Transfer Task to Send Files that match my criteria from several local sub-folders
This video demonstrates how to configure a package, using the File Transfer Task, so that it only sends local files to the remote server if they match specified criteria . Several local folders must be scanned to find the files that should be sent.How can I move files between folders on the SFTP Remote Server?
Files on a remote SFTP server may be moved by using the Rename remote files Action in the File Transfer Task component. You should just include the name of the directory where you want to move the file(s) in the path using the NewName parameter. ...