PowerShell Data Processing Extension

Rating:        Based on 1 rating
Reviewed:  1 review
Downloads: 727
Change Set: 8887
Released: Apr 24, 2011
Updated: Sep 1, 2011 by CraigMartin
Dev status: Alpha Help Icon

Recommended Download

Application PowerShell DPE Assembly
application, 18K, uploaded Sep 1, 2011 - 503 downloads

Other Available Downloads

Source Code DPE Install Scripot
source code, 5K, uploaded Apr 24, 2011 - 224 downloads

Release Notes

Overview

This is an Alpha release of the PowerShell Data Processing Extension for SQL Server Reporting Services.
The PowerShell DPE is just one assembly - PowerShellDataProcessingExtension.dll.
The DLL gets dropped to different places, depending on how you want to use it:
  • Drop it to the ReportServer folder if you only want to use it in Report Server
  • Drop it to the Business Intelligence Design Studio (BIDS) folder if you want to use BIDS with the DPE

Installation

The PowerShell script 'DeployDPE.ps1' is my sample script that does the following:
  1. Copy the DPE assembly to the ReportServer folder
  2. Update the ReportServer configuration file
  3. Copy the DPE assembly to the BIDS folder
  4. Update the BIDS config file
The following installation items are not handled by the script:
  1. Update the RSPolicy config file with Code Access Security policy for the PowerShell DPE
  2. Deploy the DPE such that it works with the ReportBuilder (haven't figured this out yet)

Code Access Security for the DPE

I find this to be the trickiest part of the DPE installation. There is an XML file checked in to the project with a sample CAS policy node. It might help you troubleshoot, or it might just plain work for you. There is also good documentation on MSDN for this.
http://msdn.microsoft.com/en-us/library/aa237713(SQL.80).aspx

Debugging

There are two general issues I run into when using a DPE

When the DPE Won't Load

I've found the SSRS Report Server logs useful when the DPE won't load.
http://msdn.microsoft.com/en-us/library/aa972243(SQL.80).aspx

The DPE Throws Exceptions

If the DPE loads but throws exceptions, then I usually copy the PDB file to the server and start debugging. The source is available on the project for you to build and debug. Again, the MSDN documenation is helpful here:
http://msdn.microsoft.com/en-us/library/aa237610(SQL.80).aspx

Reviews for this release

     
I'd been looking for a way of running PoSH scripts and display the results in SSRS reports, until now I'd had to stage results in SQL and base the reports from there, not any longer. This extension does exactly what I need, installation was as simple as running the DPE Install script. Just need to work out how to pass in parameters and I'll be sorted. Thanks for sharing Craig.
by smellypom on Sep 13, 2011 at 11:46 AM