How to attach an external file in a reporting services subscription?

Question

How to attach an external file in a reporting services subscription?

matias.buero

SSC-Addicted

Points: 441
More actions
September 10, 2009 at 7:40 am

#215023

I have a report with some text and tablix that is publish on a sharepoint services and i would like to make a data-driven subscription. The report would be embedded in the body of the mail but i need to attach external files from the file system.
I`ve been searching in the web but i still doesn´t find anything. I would like to be able to define dynamic path of the file to attach in the subscription mail.
Any ideas?
September 11, 2009 at 1:48 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 1

I'm not familiar with any way to do this. You don't have much control over the email portion and even from the tables I haven't seen a way to specify any outside files. I think you are screwed.

CEWII

matias.buero SSC-Addicted Points: 441 More actions · Answer 2

I don´t konw how it really works, but i think that may be extending ¿the job? of the subscription of report server ?

Like if it is xp_sendmail then add a clause [ @attachments= ] ¿??¿?

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 3

I can tell you without resevation that it does not use either xp_sendmail or sp_send_dbmail. If you are still using xp_sendmail I STRONGLY recommend moving to DB Mail if for no other reason that reliability.

SSRS sends mail from an internal SMTP provider. Yo don't have much control of what exactly is sent in the email.

CEWII

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 4

You could always write your own provider, but that seems to be a lot of work for not a lot of return.

Why not put the required files on an internally accessible server and then put links in to the report itself to reference these?

Steve.

matias.buero SSC-Addicted Points: 441 More actions · Answer 5

Well, i 've been trying this

EXEC msdb.dbo.sp_send_dbmail

@profile_name = ,

@recipients = ,

@file_attachments = ,

with @body_format = 'HTML' ;

and it works fine for text and tables, like the microsoft books online example shows populating a table with FOR XML PATH

And i can easly attach files, so.. i think i´m gonna try this out , scheduling it with a job.

Thanks every one.

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 6

That doesn't seem to solve the question you asked..

CEWII

boumerlin SSCrazy Points: 2023 More actions · Answer 7

You can try sp_send_dbmail from the subscription job that gets created in SQL agent, but I'm nearly 100% certain you will end up with two emails as the earlier poster is correct in stating that SSRS does not use sp_send_dbmail.

Additionally, if you change the subscription properties on the Reporting Server, it will overwrite your Agent job and not retain any settings in the job. You'll be hosed!