How To
How to set file permissions after uploading a file via SFTP?
File permissions shall be set by specifying in File Transfer Task Editor > AdditionalOptions > permissions=[number]. The [number] is calculated as a sum of the selected enumeration items for SFTP permissions. See below an example that corresponds to ...How to change a folder name in a Sharepoint document library.
The rename of folder cannot be done with Sharepoint Destination. You must use File Transfer Task and configure similar as this example. The folder name will change and the contents of the folder remain in it.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 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.FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...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. Is there a predefined component for the SFTP service "BrickFTP" (REST API)?
Support for the BrickFTP service is provided by COZYROC's File Transfer Task used with the FTPS Connection Manager. Set the Connection Type to "ExplicitTLS" and the Port to "21" in the connection manager.What is the proper date/time format for the RemoteFilter parameter on the File Transfer Task?
If you want to use a filter for the remote files that includes both the date and the time, use the following format: TimeSpan - A string in the format ##[d.]hh:mm[:ss[.ff]]#. Example: #08/06/2008# + ##1.23:45#What format should I use for the time and date in the LocalFilter parameter of the File Transfer Task?
Use a FLEE expression. The syntax for the time is: ModifiedTime >= #06/29/2023# + ##09.00:00#How can I move files on the remote server?
Files on a remote server may be moved by using the Rename remote files Action. Simply include the name of the directory where you want to move the file(s) in the path using the NewName parameter.Requirement for successful data streaming
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.
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+.
Popular Articles
How To verify Microsoft Integration Services is installed on SQL Server
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that ...How long is the grace period after the subscription has expired?
We noticed that our license is going to expire soon and we are in the process of renewing the license and it might take couple of days. We are wondering if you can provide a solution to use your product in our production system temporarily without ...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 ...