Howdy! I'm having a similar issue, except my problem happens with direct mail. The workflow completes and I'm able to retrieve my csv file because I have checked the delivery property option "Enable file to be downloaded locally". My issue is I cannot find the in the sftp. I have tried the extraction filename as follows:
format 1:
/usr/local/neolane/nl6/var/instanceName/export/TEST_DM.csv
format 2:
/sftp/instanceServerName/export/TEST_DM.csv
Note: I can read data from the sftp in (data loading file) using both formats mentioned above.
Any ideas?