I have written using automation studio where sql query and data extract activity that successfully ran and is tied to the dataextension that is defined as part of data extract activity. In the third step using File Transfer activity, I select the Option "Move a file from safehouse" . THis step also runs
THE requirement from my customer is to use only Enhanced FTP and not Safehouse as they want to audit all pushes from a particular folder in Salesforce Enhanced FTP.
Question is
I need help on extracting data from Safehouse (which shows green in automation studio) where the generated file needs to move into Salesforce ENhaned FTP. Also I am unable to check the files that is there in safehouse ftp
OR Let me know how to use automation studio where without using Safehouse , if I can push to a particular folder in Salesforce Enhanced FTP , post creation of dataextension with records.
Thanks and Regards Rajesh Natarjan