Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 FTP to another site using Transact-SQL ?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-21 : 07:54:59
Jim writes "While searching for a method to FTP file to another site, I found your article "Using FTP in Transact-SQL." Unfortunately it does the opposite of what I need.

I want to log into a FTP site on a Unix server and send a text file from my SQL server to their server using standard FTP. Initially, I was hoping to find a server object that could be called in a ASP page that performed the transfer but T-SQL sounds interesting.

I have never seen a single article, written about a Microsoft platform, that uses a FTP application. You might have thought Microsoft would have included a procedure to transfer a file to a remote server as part of a scheduled DB backup plan.

Any help will be appreciated. Thank You

Jim Leonard
Practicing SQL programmer
Graduate of Microsofts' school of hard knocks.
Survivor of Service Pack 5"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-10-21 : 09:47:01
I'm surprised Nigel hasn't jumped on this already

Here is a method for doing this : http://www.nigelrivett.net/s_ftp_PutFile.html



Damian
Go to Top of Page
   

- Advertisement -