-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathimport_subscribtions.ps1
More file actions
47 lines (37 loc) · 1.21 KB
/
import_subscribtions.ps1
File metadata and controls
47 lines (37 loc) · 1.21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
#
# A long time ago, created by github.com/corelevel
#
# Reporting Services PowerShell how to install and other info
# https://github.com/Microsoft/ReportingServicesTools
# destination SSRS catalog
$DestinationRsDirectory = "/Migrated/WMS Reports/"
# source file system folder with subscriptions XML
$SourceDirectory = "C:\Temp\Subscription\!Updated\"
# SSRS URI
$sourceRsUri = 'http://msreports/ReportServer/ReportService2010.asmx?wsdl'
# proxy
$proxy = New-RsWebServiceProxy -ReportServerUri $sourceRsUri
function ImportSubscription
{
Param
(
[parameter(Mandatory=$true)]
[string]$SubscriptionFile
)
$path = $SourceDirectory + $SubscriptionFile
$rsItem = $DestinationRsDirectory + [io.path]::GetFileNameWithoutExtension($SubscriptionFile)
Import-RsSubscriptionXml -Proxy $proxy -Path $path | Copy-RsSubscription -Proxy $proxy -RsItem $rsItem
Write-Host ("Subscription imported successfully. Source subscription file '{0}'" -f $SubscriptionFile)
}
Clear-Host
try
{
Get-ChildItem $SourceDirectory -Filter "*.xml" |
Foreach-Object {
ImportSubscription($_.Name)
}
}
catch
{
Write-Host ($_.Exception.ToString())
}