elmbrook
asked on
SQL - You do not have permission to use the bulk load statement
Hi
I am trying to do a bulk insert into my SQL database.
BULK
INSERT tblAAA
FROM 'c:\temp\aaa.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
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.
I am trying to do a bulk insert into my SQL database.
BULK
INSERT tblAAA
FROM 'c:\temp\aaa.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have the same issue but unfortunately the answer is not so simple. I do not have permissions to GRANT permissions and I've been told by the DBA that they do not allow bulk copy in any case. I need to import XML data to SQL...are there alternatives, using TSQL, to bulk load? I read of a solution to use powershell to load XML data but it uses the sqlbulkcopy command which will probably have the same issue. Again, I'm looking for a sql based solution not for someone to tell me to write a c# program to parse and load the data. Thanks!
Are you sure the login you have used belongs to the sysadmin server role?