Revision: 45934
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at May 11, 2011 08:27 by michanne
Initial Code
$path = 'C:\SQL' #cd $path $dest = "$path\rptdependencies.txt" @($a) #Gets a list of all rdl files in the directory. $files = dir | select Name | where{$_.Name -like "*.rdl"} #writes the path to a file. set-content $dest -value $path foreach($file in $files) { $xml = [xml](get-content $file.Name) #prints a line for the name of the file. add-content $dest $file.name #prints a line for each command text entry in the file. See RDL schema for other fields. $xml.Report.DataSets.DataSet |foreach{$_.Query.CommandText + "|"| add-content $dest} } #Returns the output. get-content $dest
Initial URL
Initial Description
Initial Title
SSRS RDL File Command Text
Initial Tags
Initial Language
Windows PowerShell