Re: DTS automate Reporting Services
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 11/11/04
- Next message: Jéjé: "good way for deleting unsed records..."
- Previous message: Darren Green: "Re: Spurious slow performance in SQL 2000"
- In reply to: Jean-Marc PUGIN: "DTS automate Reporting Services"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Nov 2004 00:13:00 +0000
In message <uzQW3CxxEHA.4004@tk2msftngp13.phx.gbl>, Jean-Marc PUGIN
<jmpugin@mobileworkers.com> writes
>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.
>
>
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
- Next message: Jéjé: "good way for deleting unsed records..."
- Previous message: Darren Green: "Re: Spurious slow performance in SQL 2000"
- In reply to: Jean-Marc PUGIN: "DTS automate Reporting Services"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
