Return to Snippet

Revision: 45934
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