Phil is right on target. You have to deal with the entire file before you can evaluate the number of rows. Staging seems like the only solution to me.