Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Load Extended Events via Powershell

    Finally got it to work:

    If (!$currentEvent.Fields["result"].Value.Key) {
      $row.EndResult = [System.DBNull]::Value
    }
    else
    {
    $row.EndResult = $currentEvent.Fields["result"].Value.Key
    }

  • RE: Load Extended Events via Powershell

    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...

  • RE: Load Extended Events via Powershell

    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 =...

  • RE: Load Extended Events via Powershell

    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...

Viewing 4 posts - 1 through 4 (of 4 total)