I’m getting extra columns when trying to output an SQL query to HTML. I get RowError, RowState, Table, ItemArray & HasErrors along with with my actual query results. These looks like property values attached to the object created by Invoke-Sqlcmd.
PS C:\> $myTable | ConvertTo-Html -as TABLE | Out-File C:\Test.htm PS C:\> Invoke-Expression C:\Test.htm
Any ideas how I can strip those out?