Variables may not change type during execution. Variable types are strict, except for variables of type Object.
If you want to get a list of files from a folder on the remote host using the File Transfer Task, use the 'Get remove files list' Action and set up a variable of type 'Object' to receive the list.
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
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-task If you are not sure there will be ...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. ...How to get to the root directory on a remote server
When getting the list of files from a remote server using the “Get remote files list” action with the File Transfer Task, you may need to use a special escape character sequence to get to the root of the remote directory. The typical characters used ...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.