This is a wonderful way to explore what PowerShell has to offer. Thank you.
In case it helps others, I would like to mention how I overcame a problem in the SQLPSX Part 2 article. While I was able to retrieve data from the desired SQL Server instance using Write-SmoToCsvFile.ps1, I kept on getting cryptic errors concerning
the ExecuteNonQuery call when trying to upload the csv output into the holding tables that are the source for the associated reports. I am, by the way, using PowerShell 2 on a Windows 7 box. I am running the script on this box and trying to save
the data to a remote server.
It turns out that if the source files for a Bulk Insert can be stored locally to the SQL Server or else on a remote drive. But if the latter, then UNC paths must be used to identify the source location. So in the section of the SQLPSX Part 2
article where Chad says to 'Change the variable $CsvDir ... ' and gives an example using a local drive letter, I had to use a UNC path here. While at it, I used a subfolder of that for the archive folder. Then the script to bulk load the csv data
As a small extra point, although the screenshot of the SQLPSX Report Setup shows what seems to be a VS2005 project being created, I found that the very helpful reports provided in the SQLPSX_1.6.1 distribution should be homed on VS2008 instead - they use
the tablix control amongst other things.
With a thousand thanks and many best regards