Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
raj vardhan43
Starting Member
20 Posts |
Posted - 2012-10-23 : 15:36:29
|
Hi All, I need your advice.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 ??Appreciate your help!!raj |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2012-10-23 : 16:23:41
|
hi,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 report3) create a job; after subscription of file, you send via SSIS a external word document4) 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 document5) 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-SQL6) use SQLCMD7) 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? |
|
|
raj vardhan43
Starting Member
20 Posts |
Posted - 2012-10-23 : 17:37:19
|
Thanks dude!! It gave me an idea to proceedraj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-23 : 18:24:42
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
raj vardhan43
Starting Member
20 Posts |
Posted - 2012-10-26 : 20:12:24
|
Guys thanks for your response. I solved this by using send mail task of ssis.step 1: I had created subscription for sales report to be delivered to windows file share.step 2 : I had placed the external document at the same windows file share.step 3: used ssis sendmail task to attach both the salesreport and external document to be sent to recipients.It worked well!! :)raj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-26 : 23:53:18
|
quote: Originally posted by raj vardhan43 Guys thanks for your response. I solved this by using send mail task of ssis.step 1: I had created subscription for sales report to be delivered to windows file share.step 2 : I had placed the external document at the same windows file share.step 3: used ssis sendmail task to attach both the salesreport and external document to be sent to recipients.It worked well!! :)raj
cool glad that you sorted out------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|