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?
