So after a load of very useful info in the comments after running the query suggested by @AlanSchofield and noting the PK column error "No identity column defined", I requested help from our DBA who has created a cloned table and defined the PK column as an identity column and now my bulk upload is working with the whole file uploading in one run.

Thanks again to everyone for the help, much appreciated.