Viewing 4 posts - 1 through 4 (of 4 total)
Finally got it to work:
If (!$currentEvent.Fields["result"].Value.Key) {
$row.EndResult = [System.DBNull]::Value
}
else
{
$row.EndResult = $currentEvent.Fields["result"].Value.Key
}
March 5, 2019 at 5:12 pm
Thank you aakash9 once again.
The problem is still "Invalid storage type: DBNull. Please use DBNull instead.""
As per your suggestion, I changed the datatype of $EndREsult from Int to...
March 5, 2019 at 11:55 am
Thank you aakash9!
Now, I'm getting this error:
Exception calling "NewRow" with "0" argument(s): "Invalid storage type: DBNull."
It is referring to :
$events =...
March 5, 2019 at 9:05 am
Not working. Thank you.
The file C:\Program Files\Microsoft SQL Server\130\Shared\Microsoft.SqlServer.XEvent.Linq.dll exists but we still get this error message:
Assembly not found. Loading it from C:\Program Files\Microsoft SQL...
March 4, 2019 at 8:23 pm
Viewing 4 posts - 1 through 4 (of 4 total)