Old post, I know.  But for future readers, this can be accomplished from SSRS using Deztec's SFTP Destination extension for SSRS.