Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Bulk Insert

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-06 : 08:56:43
Jack writes "Hi

I have coded a Stored Procedure that import data from a text file to the database useing BULK INSERT statement. I get the following error:

Server: Msg 4834, Level 16, State 1, Line 1
You do not have permission to use the BULK INSERT statement.

What must I do."

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-06 : 09:11:01
ask the DBA to grant sysadmin or bulkadmin to you


KH

Go to Top of Page
   

- Advertisement -