If you use this task to stream data, set the RetainSameConnection parameter to TRUE on the connection manager. Otherwise, the connection will be closed before all the data is transferred.
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the File Transfer Task can be found at the following link. For many of the components you can find ...
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 ...
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 ...
If you are getting the subject error when using the File Transfer Task or the SFTP Task to transfer files and the transfer works successfully using a different tool, then check if you are using a semicolon (;) in your password. If so, this is what is ...
Starting from 1.4 SR-3 the data flow can be completely dynamic - the need to have one common column across different iteration sets is no longer required. To have completely dynamic components, you have to remove all statically defined columns (both ...