SQL Agent and DTSX SSIS package: How to get it to email or ftp the output file? (SQL Server 2016) I have a dtsx, and can get SQL Agent to run it as a package on the file system.

So that drops the resulting xlsx to disk.

How can I get that xlsx emailed or sftp'd somewhere?
If you're not up to modifying the SSIS package to incorporate email or SFTP, you could add an additional step to the SQL Agent job.

A Transact-SQL script step could be used to call sp_send_dbmail to email the file to the appropriate recipient.

An Operating System step could be used to run an SFTP client (e.g. WinSCP) to transfer the file (though this would probably be better done in another SSIS package--example).