After digging into a little deeper, I think I figured out the source of the problem. There are several tasks before the data flow task, and that task is on a conditional constraint with several others (based on what code is passed from the job, it will run a different branch). What I'm finding out is that it's running the count before it runs the bulk insert. The Execute SQL task is after the Data Flow task, so is this normal behavior?