Post reply

Generate Reporting Services Report thru DTS

  • December 20, 2005 at 10:44 am

    #68636

    Within SQL2000, does anyone out there know how to, within DTS, run a reporting services report, and save it as .pdf in a particular share (which will be a global variable?)

    Thanks in advance for any help with this!

  • December 20, 2005 at 6:03 pm

    #610753

    if you can run your reporting services reports as a batch file, thens use Execute Process Task to call the batch file.

  • December 21, 2005 at 7:32 am

    #610833

    Amplifing the earlier response - You can construct a batch file to call the rs.exe utility of reporting services to execute a script that in turn causes your required reports to be rendered in your chosen format, in your instance PDF.

    Help on rs can be found via reporting services books on line, look up the reportingservice.render method.

    The following article is short and to the point for how to construct the script file that renders the report:

    http://www.sqljunkies.com/Article/B197B9E7-EF3D-4D70-9B5E-47B74E57EF38.scuk

    You could use the -v option of rs.exe to pass in the global variable from the DTS package.

  • December 21, 2005 at 8:56 am

    #610867

    I would create a subscription to the report and have it save the file to your share.  When you have a report you can setup a subscription to run at a specific time and export the results in pdf csv or whatever and put it in a share.

  • December 29, 2005 at 3:04 pm

    #612065

    Thanks all.  The example using the rs.exe utility was just what I needed.  A tip for anyone else using this...if you pass in multiple parameters on the command line using -v, you must specify -v for EACH ONE.

    Thanks All!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply