sql server dts: Hi,

We need to automate from DTS the execution of REPORTING SERVICES to run
predefined reports
against their Data Source (a SQL or OLAP DB).

We are searching for simple methods to do it:
- Stored Procedure
- EXE command line (dynamic using DTS global variables)
- simple script

I think a simple solution could be usefull for a lot of people.

Many thanks.

Best Regards.

Jean-Marc.

In message <uzQW3CxxEHA.4004@tk2msftngp13.phx.gbl>, Jean-Marc PUGIN
<jmpugin@mobileworkers.com> writes
[quoted text, click to view]

Probably the easiest way would be to use the RS script utility (rs.exe)
.. You could then call this from the Exec Proc Task. You could
change/write the script dynamically via an ActiveX Script Task depending
on how much flexibility you require.

Saying that I don't know how write an RS script to run a report, but I'm
sure there are plenty of people who do over in the RS group.
- microsoft.public.sqlserver.reportingsvcs

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org