FTP help

I am trying to find out if there is a way that I can automatically have sql
server send a file from a folder and ftp it to a dialer.
what happens currently is the server generates a text file and manually i
have to ftp it to a dialer, i was hoping i can automate this.Use a scheduled application that wakes up and checks the folder for new
files to FTP. FTP is much simpler to accomplish from command line, C#, etc.
To do it in SQL would just mean putting a T-SQL wrapper around those
applications, and it doesn't make a lot of sense. Seems like taping two
hammers together and trying to hang a picture with the heaviest end.
"Justin" <Justin@.discussions.microsoft.com> wrote in message
news:8D29C359-19D7-45A8-8004-CCD3C4E640CB@.microsoft.com...
>I am trying to find out if there is a way that I can automatically have sql
> server send a file from a folder and ftp it to a dialer.
> what happens currently is the server generates a text file and manually i
> have to ftp it to a dialer, i was hoping i can automate this.|||I would look into using a CmdExec step of a SQL Server Agent job. The
command-line FTP application is scriptable.
-Alan