1) This process works if the pivot table is small enough (resultant qvd size < 25 MB).2) I can export to qvd manually (almost any size table, up to 6+ million rows and 72 columns) using the right-click, export, save as qvd.

Is there so limitations to the API or to this exportEx command? Or is there some setting somewhere that I can modify to permit large file exports to qvds?

When I changed the vbscript to point to a local drive letter e:\ rather than the UNC path of the SAN which we are using, the export worked!

I don't know why the UNC file path is not working. This is still an issue, as we have multiple development and production servers, with SAN attached directly to only one of these servers. So, I may want to run this process (and save the exported QVD to the SAN) on a different server than the server which has the SAN attached, thus requiring UNC.