Select-PWSQL Error

Anyone experiencing similar problems?

After updating to latest PWPS_DAB version 2.0.1.0 I am getting an error running any existing scripts using Select-PWSQL with an output to an Excel spreadsheet.

The SQL results are displayed but the error occurs when attempting to write to Excel

e.g. Select-PWSQL -SQLSelectStatement $SQLstr1 -OutputFile 'c:\temp\file.xlsx'

Error:-

WARNING: Error: Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17' or one
of its dependencies. The system cannot find the file specified.
at PWPS_DAB.XLSXDataSetTools.DataSetToXLSXFast(DataSet ds, String sWBName)
at PWPS_DAB.SelectPWSQL.ProcessRecord()

In the meantime I will will try rolling back the PWPS_DAB version to see if I can get it working again

Parents Reply Children