I have a SALES report which i send it to users everyday by using SSRS subscription (delivered by email). My manager asked me to attach a external word document along with this report.
So the user has to receive a) the SALES report b) the external word document.
Is it possible to attach/send an external document along with SSRS subscription delivered by email ??
what you can do is: 1) add content of word document into report (copy-paste text to report) 2) save word document as JPG and insert it as picture to report 3) create a job; after subscription of file, you send via SSIS a external word document 4) create SSIS package where a) you export the query to excel/pdf (like you would do it in report) and b) add to sending email with export also the word document 5) a) save export of report to windows file share and b) send the saved export with word document to recipients using SSIS or regular T-SQL 6) use SQLCMD 7) do some programming in c#
definitly it is not out of the box solution on SSRS 2008 R2 or lower versions. Maybe SSRS 2012 supports this?
we did a similar requirement using SSIS. After generating report as a PDF in a file share we configured SSIS to send mail to recipient list with PDF and also other required information as attachments
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Can we attach/send External file along with SSRS s
Posted - 10/23/2012 : 15:36:29
