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 2005 Forums
 Transact-SQL (2005)
 Export to FTP-server from T-Sql is that possible ?

Author  Topic 

jan.nooitgedagt
Starting Member

4 Posts

Posted - 2009-02-18 : 05:05:06

Is it possible to make an export to an FTP-server using Transact SQL ?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-02-18 : 06:25:15
Everything is possible. If it's the preferred way is another question...

But you can run command line scripts using xp_cmdshell so you can pretty much do anything as with a normal cmd-window. Just keep in mind that you loose scope at the end of each command. What you can do though is to create a .bat-file to make things a little easier and just fire it off using xp_cmdshell.

- Lumbago
Go to Top of Page
   

- Advertisement -