SQL Server Performance

Using Bulk Insert with SQL Server 2005

Discussion in 'SQL Server 2005 General Developer Questions' started by Ninel, Aug 29, 2006.

  1. Ninel New Member

    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,

Share This Page