>> The requirement is that the store should be modified in such a way that it should drop the output file to Server1 itself(The server from where it is getting called).
OK, no problem, Server 1 calls the extract on server 2 andf server 2 sends it back to server 1.
You have three options:
1 - Wait until the tab-delimited file is completed and have the script open-up a secure connection to transfer it back to server 1 (ftp, vpn, ssh).
2 - Open a connection back to server one, and write the records to a flat file on server 1, bypassing the write to server 1.
3 - Call BC support at 800-766-1884. We can get this done in just a few hours . . .
If you are not familiar with Oracle shell scripting, see here, especially the examples in the script download:http://www.rampant-books.com/book_0701_shell_scripting.htm
This is about a 4-10 hour coding task, including testing time . . .