I found this link from Google to demo how to send a file to ftp site by using T-SQL script, I want to ask how can I include this "streamed mode" command for my ftp transmission.
quote "SITE ASCII_RECSEP=NONE"
I am currently submit my file to a ftp site manual by using ftp command in Command Prompt like this, therefore I can enter this command everytime but how to code it into a T-SQL script?
This is the step for me to send file to ftp site by manually. In step 2 I enter (quote "SITE ASCII_RECSEP=NONE") for streamed mode.
1. c:\>ftp ftp.businesspartnerserver.com
...enter user name and password
2. quote "SITE ASCII_RECSEP=NONE"
3. put d:\sendthisfile.doc