You are here:
Microsoft SQL 2008 Database Server Microsoft SQL 2008 Database Server

You do not have permission to use the bulk load statement

I had a problem when trying to bulk load a CSV file into my Microsoft SQL 2005 database. The error was "You do not have permission to use the bulk load statement". It turned out to be quite a simple solution.

The solution: It was simply a permission issue and your SQL login needs to be added to the bulkadmin server role. To do this connect to your SQL server as admin or SA and then go to "Security" > "Server Roles". Then right click and select properties. Then using the add button, add your login to this role. Retry your bulk statement and you should be ready to go.