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!