I have a task that exports data from Salesforce to a flat file on the server where the secure agent is running. I use a post processing command to copy the data from the target file to a new file with the date appended to the end of the file name using the following command:
After the task runs, I need to take the file that was created and FTP it to another server. I can access the FTP server, but how do transfer the file? I created a new FTP connection and tried to create another data service task, but I'm not sure how to setup the source and the target?
The source file is never the same because the date is appended to the end of the file name and it doesn't even exist when I'm trying to create the new task.
What is the best automated option to use FTP and transfer the file?
Thanks for any help.