How to select row and column name where field is null?
there is no need for using slow cursors ...

Insert into table_error
select 'error - ' + Cast(ID as Varchar(20)), @uploads, GetDate() 
from Header 
where  [name] is Null or [zip] is Null or [age] is Null or [city] is Null