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.


This task is made up of 4 steps:

Step Name Tool What it does
Daily Schedule Event: Schedule Determines how frequently the task is to run.

Scheduling a Task

Retrieve Information Input: 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 Report Format: Run Microsoft Reporting Services Uses data obtained by the query and presents it in the report.

Running a Micosoft Reporting Services Report

Send Email Output: 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