SQL Server Performance Forum – Threads Archive

Using Bulk Insert with SQL Server 2005

I have a web page that prompts a user to select a csv file. Using a Bulk Insert the data is loaded into a SQL Server 2005 table. I have been using the Bulk Insert with SQL Server 200 with no problems, but with 2005 I am getting the error "You do not have permission to use the bulk load statement". My web.config file has the following connection string:
<add key="connectionString" value="Server=(local);Database=BroadCastOne;trusted_connection=true" />
I’ve given bulkAdmin role to the ASPNET user. It’s still not working. What am I doing wrong? Any help is greatly appreciated,
Ninel

---

]]>