split text file by 1mln ln

$txtStream = New-Object system.IO.StreamReader("D:\Downloads\scom_reports\SB\scom.csv")
$fileCounter = 0;

while(-not $txtStream.EndOfStream){
    "Create file d:\temp\sb_$($fileCounter).csv" | Out-Host
    $writer = [System.IO.File]::AppendText("d:\temp\sb_$($fileCounter).csv")

    for($i = 0; $i -lt 1000000; $i++){
        $writer.WriteLine($txtStream.ReadLine());
        if ($txtStream.EndOfStream){
#           $writer.Flush()
#           $writer.Close()
#           $txtStream.Close()
            break
        }

    }
    $fileCounter++
    $writer.Flush()
    $writer.Close()
}

$txtStream.Close()