Building a task that sends a Microsoft Reporting Services Report by email

This example will create a task that automates the running of a Microsoft Reporting Services Report. The task runs regularly based on a schedule, it queries the database of a database system, runs a Reporting Services Report and sends the report via email to a specified user.

3

This task is made up of 4 steps:

Step NameToolWhat it does
Daily ScheduleEvent: ScheduleDetermines how frequently the task is to run.

Scheduling a Task

Retrieve InformationInput: Database Query (ODBC)Reads the database of a business system to find details to map to parameters in the report.

Querying a database

Run MS Reporting Services ReportFormat: Run Microsoft Reporting ServicesUses data obtained by the query and presents it in the report.

Running a Micosoft Reporting Services Report

Send EmailOutput: Send Email (SMTP)Sends an email containing the report
Sending an email

To read about designing other tasks see:

Task Design

Related Articles

Running a Microsoft Reporting Services Report

Introduction The ‘Run Microsoft Reporting Services’ is a format tool used to run a pre-designed report. It outputs the report in one of a range of formats which can be consumed by other tools in TaskCentre. The tool can consume a recordset or an…

Read More
BPA-8238