SSRS 2010 WebService自动化部署：如何上传PNG图片？

Great question—this is a common pain point when automating SSRS deployments, especially for shared resources like logos that need to be reused across multiple reports. Let’s break down your two main options for 100% unattended setup:

1. Use the SSRS 2010 Web Service (Recommended) #

The official SSRS 2010 Web Service (ReportService2010.asmx) has a CreateCatalogItem method specifically designed to upload shared resources like images. This is the most reliable approach for unattended scripts because it uses the supported API, avoiding filesystem hacks that can break with updates or permission changes.

Here’s how to implement it:

• First, reference the web service endpoint (usually at http://<your-ssrs-server>/ReportServer/ReportService2010.asmx) in your script.
• Read your PNG logo into a byte array (this is how the web service accepts binary files).
• Call CreateCatalogItem with the correct parameters to upload the image to a shared folder in SSRS (so all your reports can reference it easily).

Example PowerShell Script (Perfect for Unattended Deployment) #

# Load the SSRS web service proxy (uses your current credentials; adjust if needed)
$ssrsProxy = New-WebServiceProxy -Uri "http://your-ssrs-server/ReportServer/ReportService2010.asmx" -UseDefaultCredential

# Define paths and names
$localLogoPath = "C:\Deployment\Assets\CompanyLogo.png"
$ssrsTargetFolder = "/Shared Resources" # Create this folder in SSRS first if it doesn't exist
$ssrsImageName = "CompanyLogo"

# Read the logo file as a byte array
$logoBytes = [System.IO.File]::ReadAllBytes($localLogoPath)

# Set the MIME type (critical for SSRS to recognize it as a PNG)
$imageProperties = @()
$mimeProperty = New-Object Microsoft.ReportingServices.ServiceRuntime2010.Property
$mimeProperty.Name = "MimeType"
$mimeProperty.Value = "image/png"
$imageProperties += $mimeProperty

# Upload the image to SSRS
$ssrsProxy.CreateCatalogItem(
    "Image",          # Item type (must be "Image" for image resources)
    $ssrsImageName,   # Name of the image in the SSRS catalog
    $ssrsTargetFolder,# Parent folder path in SSRS
    $true,            # Overwrite existing image if it exists
    $logoBytes,       # Binary content of the image
    $imageProperties, # Metadata (MIME type here)
    $null             # Ignore warnings for unattended runs
)

Once uploaded, you can reference the image in your report headers using its SSRS path (e.g., /Shared Resources/CompanyLogo). This will work seamlessly with your existing automated report deployment workflow.

2. Filesystem Copy (Not Recommended, But Possible) #

If you need a quick filesystem-based workaround (note: this is unsupported by Microsoft and less reliable for unattended setups), you can copy the PNG directly to the SSRS server's resource directory:

• The default path for SSRS resources is usually C:\Program Files\Microsoft SQL Server\MSRS10_50.<YourInstanceName>\Reporting Services\ReportServer\Resources
• Create a subfolder matching the SSRS catalog path (e.g., Shared Resources if your images are stored in /Shared Resources in the SSRS portal)
• Copy your PNG into this subfolder, ensuring the SSRS service account has read permissions on the file
• Important: You may need to restart the SSRS service or clear the server cache for the image to appear in reports. This method can break if SSRS's directory structure changes during updates.

Final Recommendation #

Stick with the web service approach—it’s the only supported, reliable way to automate image uploads for SSRS 2010. It integrates cleanly with your existing deployment scripts and avoids the pitfalls of filesystem manipulation.

内容的提问来源于stack exchange，提问作者Santiago San Martin