I usually use SSMS to create a VIEW where I write my query and make sure there are no empty values. It seems you are reading from live data which theoretically all fields should have a value but in the real world that is not always true. Redo the query by filtering empty or Null values (depends) so that you don't get those errors. Normally, I look at my data in T-Sql so that I know how many records I'm expecting, how many I will remove because of missing data or if possible alter the table and fill the missing data. You are making the assumption that everything is there and it should work. RS is telling you that some fields are missing.