Mac1986 (3/18/2016)
I got it working. we can archive this thread. Thanks a lotforeach ($line in $ReturnString)
{
$array = @()
if ($line -notmatch "ID, Active, User, Client, Machine, StartTime, Duration, KernelTime, UserTime")
{ $ProcID, $Active, $User, $Client, $Machine, $StartTime, $Duration, $KernelTime, $UserTime= $line.split(",",9) }
Why would you use PowerShell for such a thing? Why not just use BULK INSERT?
--Jeff Moden
Change is inevitable... Change for the better is not.