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 occurs when you have specified a Flat File connection manager for the “Local” parameter of the File Transfer Task. The error message is saying that you need to use a different type of connection manager. You should be using the File connection manager instead of the Flat File connection manager. Even if the local file(s) you are working with are .txt or .csv files, use the File connection manager.
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: 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 ...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 ...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 ...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. ...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 ...