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 you are using the Send Files Action, then the only parameter that is used in the Flat File connection manager is the ‘File name’ parameter. When you set up the Flat File Connection Manager, browse to the folder where the file(s) are located and choose a single file.
If you wish to upload more than one file from that folder, you can re-open the Flat File connection manager after closing it and remove the file so that the ‘File name’ is pointing at a folder containing multiple files. This will also work with the Send Files Action of the File Transfer Task.
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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 ...Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: File usage type of connection '<CONNECTION MANAGER NAME>' should be 'FolderExists’
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>: File usage type of connection '<CONNECTION MANAGER NAME>' should be ...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 turn on verbose logging for the File Transfer Task or the SFTP Task?
To turn on verbose logging in the SSH connection manager, open the Advanced tab can click on the checkbox next to "Verbose log" and make sure "Use binary transfer" is also selected. Error Message: Local path is not a file path or you do not have permission to access it.
Action: When running a package in Visual Studio that is using COZYROC File Transfer Task and a File Connection Manager pointed to Example - E:\Some_Directory, the package runs fine. However, after deploying the package to SQL Server Agent, the ...