SQLTeam.com | Weblogs | Forums

Upload files to ftp site


#1

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!


#2

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.


#3

Thanks a lot!