My point is why use a database process to act on a file system. Let the database system do what it is intended to do and, likewise, let the file system do what it is intended to do.

You can probably use SSIS to trigger FTP processes. The question is WHY would you do that.

I CAN run across the freeway at rush hour. Just because I CAN doesn't mean I SHOULD.