I export an Excel file from SSRS to a particular folder by running the SSRS job created by the SSRS subscription from within SSIS. The file is exported and then is sent by email to a user but the problem is that you can't preview the Excel file from within any email. I've tried a couple of different files created the same way and a couple of different email services to test, and it never allows previewing the file. The file is actually small, so it isn't the size.
The file is attached but there is no preview
I'm hoping someone might be able to provide a solution to this. Let me know if you have any questions. Oh, I'm running on Windows Server 2012 R2, SQL Server 2017, and the most recent updates of SSRS and SSIS. I hope that helps.
Thanks!