SQLTeam.com | Weblogs | Forums

Upload files to ftp site


Hello everyone,

I need to upload 2 files to a ftp site daily and the process needs to be automated, can you guys please help me. Any help would be appreciated. Thanks in advance!


SSIS would be one good option.
Create a SSIS package with FTP task to upload the file to FTP server and then schedule the package via SQL agent job based on your frequency.


Thanks a lot!