I am trying to set up a monitor that will copy any new files with a specific file name over to an archive directory. The monitor seems to work fine, but when it copies the newly created files to the archive, it also copies the entire directory structure as well. Is there a way to just copy the files over?
The only option you have is to create a WorkSpace. Do the SFTP | Get and bring the files back to your WorkSpace as a destination. Then, use the Copy Task destination filelist variable as the Source Variable for the Copy to Final Destination with the Advanced option to Flatten.
Delete the Workspace when done.
Lead Solutions Consultant