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)
 transfer files

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-12-15 : 07:17:02
hi

i am not sure that i can ask here.

how can i transfer file from my local server to ftp server via VBScript or T-sql?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-15 : 07:18:30
use ftp task available in ssis
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2008-12-15 : 07:35:03
visakh16,i need to do it in DTS(2000)-this is the problem
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-12-15 : 08:35:01
xp_cmdshell inside stored procedure - can be executed directly as a Job:
http://haacked.com/archive/2006/04/21/SQLStoredProcedureToFTPFilesFromSQLServer.aspx
Go to Top of Page
   

- Advertisement -