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.
| Author |
Topic |
|
kowani1
Starting Member
42 Posts |
 Posted - 2007-04-03 : 22:29:49
|
| Hi All,I need to ftp a copy of our Production Database to our external vendors, and need to know if there is a way I can do everything via SQL.I've created a package to backup/compress and make it available so I can upload the zip file onto the vendor's ftp site.I have opened up my ftp port and the have the connection details for the vendor. FTP from the command prompt works, but I need to automate all of this via a overnight job.Please help me!!!.Jungle DBA |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
FTP Backup Via DTS Package