Deploying the PowerShell DPE

Good documentation already exists for deploying a Data Processing Extension.

Depending on your needs, you may need to deploy the DPE more than once.

Deploying the DPE to the Report Server

If you are using the DPE at the server then you need to deploy the DPE to the report server.

Deploying the DPE to Business Intelligence Development Studio (BIDS)

The DPE also needs to be copied and configured to the folders where BIDS lives. If this step is skipped then BIDS can't be used to generate reports that use the PowerShell DPE (even it you're successfully installed it on the Report Server).

Deploying the DPE for Report Designer 3.0

I haven't figured out how to do this yet. Not a high priority for me because I mostly use BIDS to develop reports using the PowerShell DPE.

Using the Install Script: DeployDPE.ps1

A script is included in the PowerShell DPE project that can be used to install the DPE. This is a pretty rough script, so use it at your own risk! Your mileage may vary.

Configuration Snippet for the rssrvpolicy.config File

In order for the DPE to be loaded by SSRS a CodeGroup item needs to be added to the rssrvpolicy.config file. The sample below is the one that works on my machine.
NOTE: this is Code Access Security, so my sample is not the only way to do it.
<CodeGroup class="UnionCodeGroup"
    Description="Code group for the PowerShell data processing extension">
    <IMembershipCondition class="UrlMembershipCondition"
        Url="C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\PowerShellDataProcessingExtension.dll"

Last edited Nov 17, 2011 at 6:10 PM by CraigMartin, version 6


No comments yet.