Thankyou for sharing the details about resolution of your query. It would certainly help others experiencing the same thing in future and can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.
'From' and 'To' path options expects the path to be pointing to the folderpath and not the filename. Removing the filename from the 'From Path' option helped in resolving the issue.
For example:
From: FOLDER/SUBFOLDER
To: FOLDER/SUBFOLDER/ARCHIVE
This functionality also works well for the Wildcard file mode option. ADF identifies the file being processed and moves it from the 'FROM' to the 'TO' directory specified.
Kindly consider accepting the answer by clicking on Accept answer
button. Thankyou