Hi Folks,

I am at an architectural crossroads here and I need some input from you
guys who may have encountered this before.

I currently have DTS set up where we query the database, update an
excel spreadsheet and email that spreadsheet to internal and external
partners for analysis. This process is scheduled to run twice a day
and there is a potential for several thousand reports. We currently
run several dozen reports and the output files are around 80KB - 1MB.
These queries look for errors (eg Error Y) amongst several thousand
files that enter our system daily that is stored in the database . The
errors found in these files would then need further analysis or
correction.

I would think it would be quite a challenge to maintain the increasing
volumes of emailed files.

I would like to have a visual dashboard like a barchart for each file.
This barchart would show the number of errors found in each file daily
Eg Chartname: Error Chart for File A. X-Axis: Date, Y-Axis: Number of
Error Y.

This is so that I can zero in on the files that need addressing much
more quickly rather than having to open each emailed excel attachment.
For instance, some barcharts would show no error ys, others just afew,
and others awhole bunch of these same errors.

Is there a way to integrate DTS with a Microsoft Report Server and
publish the output from the queries (to the report server) the same
time the excel file is generated? If so what are the
components/infterfaces that are needed or is there a task icon that I
can use? Or can anyone just point me in the right direction?

I do not want to start from scratch and recreate the same queries
(already in DTS) in the MS Report Server to generate the charts.

I hope this all makes sense. Your inputs would be greatly appreciated.