Sharepoint rows are getting dropped

[Blewis21]

Does anyone know why this is happening? 

it can read all 170k, but then it just removes 90% for a reason I can't figure out when it goes to the next step. 

I tried removing all columns during the read except 1 column (ID record), but still the same 17k

I tried replacing the file in sharepoint and removed all the columns except 1 (ID record). then when I read the file, all 170k records came through

I then replaced all 25 columns with the the ID record in sharepoint. then when I read the file only 8k records came through ( did this to see if nulls/blanks were throwing it off)

This sounds like a memory issue. is there a way around this issue?