Search code examples
sql-serverreporting-servicesssisetlssis-2008

How can I add the server name to the subject line of a SSIS subscription email?

In Microsoft SQL Server Integration Services (SSIS) RDL report files uploaded are often set with the ability to send out periodic email alerts. On the SSIS 2008 system, this is called "Subscriptions". When a new email alert is set up, there are system defined strings in the Subject line which is presented as default as:

@ReportName was executed at @ExecutionTime

How can I add a new item to this subject line for the server name?

Solution

  • We can use @ReportServerUrl to get the reporting Server in RDL files as Hadi mentioned. But for the subscription subject line itself, SSRS only allows for two variables, @ReportName and @ExecutionTime.

    References