FTP B/u
-
Does anyone know of a way to make a back up of a database and have it FTP to another server?
Can this be done with a DTS package?
Thanks,
-Carlos
-
You can use xp_cmdshell to call the command-line ftp client. If you've got all the commands to execute in order (including the login), you can use the -s:<filename> to tell the client to execute the script. The FTP task in DTS can retrieve but it does not push files. You'd have to do something similar to what I just described (or use an ActiveX control... there are some out there that do FTP) in order to push a backup to a different server within DTS.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply