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#
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
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#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 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 ...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: 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 ...