SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Can we attach/send External file along with SSRS s
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

raj vardhan43
Starting Member

USA
20 Posts

Posted - 10/23/2012 :  15:36:29  Show Profile  Reply with Quote
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

Switzerland
746 Posts

Posted - 10/23/2012 :  16:23:41  Show Profile  Reply with Quote
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 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?
Go to Top of Page

raj vardhan43
Starting Member

USA
20 Posts

Posted - 10/23/2012 :  17:37:19  Show Profile  Reply with Quote
Thanks dude!! It gave me an idea to proceed

raj
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/23/2012 :  18:24:42  Show Profile  Reply with Quote
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/

Go to Top of Page

raj vardhan43
Starting Member

USA
20 Posts

Posted - 10/26/2012 :  20:12:24  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/26/2012 :  23:53:18  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000