troubleshooting Question

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

Avatar of KANEWONG
KANEWONG asked on
Microsoft SQL ServerFile Sharing Software
1 Comment1 Solution363 ViewsLast Modified:

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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros