Link to home
Start Free TrialLog in
Avatar of KANEWONG
KANEWONG

asked on

How to include streamed mode in T-SQL script, if it is used for ftp connection


Hi;

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

4.quit
ASKER CERTIFIED SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial