SQL - You do not have permission to use the bulk load statement
Posted on 2011-10-12
I am trying to do a bulk insert into my SQL database.
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
However, when I try this I get 'You do not ahve permission to use the bulk load statement.
The database is on my local machine so I login using SQL authentication.
I select security - logins - name - right click and select properties and go to server roles. I have bulkadmin, sysadmin and public selected.
I am not sure what is going on here but it would be good to import my CSV file.
Any help is appreciated.