Re: FTPing and Calling an EXE from a SQL Statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris Hayes (cp.hayesATsbcglobal.net_at_nospam.nospam)
Date: 01/22/05 

Date: Sat, 22 Jan 2005 00:16:26 -0600

Thank you Michael!

Like I posted in my post to Dan Guzman, I'm now a Manager of Developers and
I need A LOT of help for my Developer to help them achieve the tasks that we
are assigned and this helps so much...

Thank you, thank you, thank you!!!

I will try to reciprocate on the MSDN Message Boards and help others as time
permits!!! I'm a firm believer in helping and sharing knowlegde!!! I might
have to do this in my off hours and in the name of my off hours
company...but I will help where I can!!!

Thank you again,

Chris

"Michael Cheng [MSFT]" <v-mingqc@online.microsoft.com> wrote in message
news:mZJJSWEAFHA.768@cpmsftngxa10.phx.gbl...
> Hi Chris,
>
> Thanks for your posting!
>
> From your descriptions, I understood that you would like to use FTP within
> T-SQL statement and you would like to know whether it is possible for you
> to execute exe file directly from T-SQL statement. Have I understood you?
> Correct me if I was wrong.
>
> For the first questions, yes, we are able to create FTP scripts 'on the
> fly' and I find MVP oj have a good sample here
>
> exec master..xp_cmdshell 'echo open ftp.{server name}.com > c:\ftp.input'
> exec master..xp_cmdshell 'echo {user}>>c:\ftp.input'
> exec master..xp_cmdshell 'echo {password}>>c:\ftp.input'
> exec master..xp_cmdshell 'echo put {filepath & filename to
> send}>>c:\ftp.input'
> exec master..xp_cmdshell 'echo bye>>c:\ftp.input'
> exec master..xp_cmdshell 'ftp -s:c:\ftp.input'
>
> I am not sure what you would like to do with FTP so that I was not able to
> provide more infomation on this. Here is another thread that I think might
> help much.
>
> http://groups-beta.google.com/group/microsoft.public.sqlserver.server/browse
> _frm/thread/215cb2fd0459ce64/df62a4137206e879#df62a4137206e879
>
> For the second questions, you could use xp_cmdshell to execute the exe
> files, however, ONLY console will be executable and no inputs after
> execution. Check xp_cmdshell for more detailed information.
>
> BTW, I would like to suggest you how to find the some common issue with
> the
> help of google.com, which I think will be the quickest way for you to get
> the answer
>
> http://groups-beta.google.com/advanced_search?q=group:microsoft.public.sqlse
> rver.*
>
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
>
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---------------------------------------------------------------
> Get Secure! - http://www.microsoft.com/security
>
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Relevant Pages

  • Re: FTPing and Calling an EXE from a SQL Statement
    ... "Chris Hayes" wrote in message ... I understood that you would like to use FTP ... >> to execute exe file directly from T-SQL statement. ... >> Online Partner Support Specialist ...
    (microsoft.public.sqlserver.programming)
  • Re: Run scripts from WITHIN the FTP environment
    ... Open up FTP from their Windows command prompt. ... Manually log into an FTP server with the UserName and Password I ... to execute a script in the directory they are in. ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Run scripts from WITHIN the FTP environment
    ... Open up FTP from their Windows command prompt. ... Manually log into an FTP server with the UserName and Password I ... to execute a script in the directory they are in. ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: VSFTP
    ... I have a Windows based server running on an XP machine. ... would be able to execute scripts or other executables from within their ... The server I speak of is the latest version of Serv-U FTP on the XP box, ... Here is a copy of the "Rights" section of the Serv-U help file. ...
    (linux.redhat.misc)
  • Re: How to port surf using C/C++ sockets in windows
    ... Taking control over someones computer is something criminal, ... This causes the CPU to execute the code which was sent by bad guy. ... Read FTP RFC,http://www.faqs.org/rfcs/rfc959.html ... I Thank You for the RFC link that you provided for FTP., ...
    (microsoft.public.win32.programmer.networks)