its not the folder access which is causing the issue, its the Bulk insert task which required sysAdmin, BulkAdmin role associated with the User Login.

you can check it if you remove the bulk insert option and just insert the data in to a random table in your database or write another file from the source file.