dbTalk Databases Forums  

automate REPORTING SERVICES from DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss automate REPORTING SERVICES from DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jean-Marc PUGIN
 
Posts: n/a

Default automate REPORTING SERVICES from DTS - 11-10-2004 , 03:45 AM






Hi,

I need to automate the execution of REPORTING SERVICES from DTS in SQL
Server 2000.

As most REPORTING SERVICES are exposed via SOAP, I need a basic/simple/old
fashion
method to automate RS execution from DTS.

It could be a T-SQL statement ideally or a EXE command line or a simple
script.

I think it could be a common need for a lot of people

Many thanks.



Reply With Quote
  #2  
Old   
Jon Jahren
 
Posts: n/a

Default Re: automate REPORTING SERVICES from DTS - 11-11-2004 , 08:14 AM






Jean-Marc,
Check out the command-line rs utility in Reporting Services. You can use
this to deploy and run management scripts written in VB.NET. Reporting
Services includes sample scripts that you can check out for use with rs.

Jon Jahren

"Jean-Marc PUGIN" <jmpugin (AT) mobileworkers (DOT) com> wrote

Quote:
Hi,

I need to automate the execution of REPORTING SERVICES from DTS in SQL
Server 2000.

As most REPORTING SERVICES are exposed via SOAP, I need a basic/simple/old
fashion
method to automate RS execution from DTS.

It could be a T-SQL statement ideally or a EXE command line or a simple
script.

I think it could be a common need for a lot of people

Many thanks.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.