cmille19 (10/8/2008)

---

I see a mistake in the article where I set the archive and data directory to the same directory. Here's what I have in my production script Write-SmoCsvToDb.ps1:

$CsvDir = "$scriptRoot\Data\"

$arcDir = "$scriptRoot\Data\Archive\"

And here's what I have in my Write-SmoToCsvFile.ps1

$dir = "$scriptRoot\Data\"

You can use the $scriptRoot variable which is set at the beginning of each script or you can specify the path. Ensure the archive and data directories exist. The Write-SmoCsvToDb.ps1 script will create a subdirectory under \Data\Archive\ for each run and NTFS compress the subdirectory.

Sorry about the error -- Let me know if this works and I'll correct the article.