Post reply

Using Bulk Insert with SQL Server 2005

  • August 29, 2006 at 9:59 am

    #67742

    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

  • August 29, 2006 at 12:10 pm

    #657330

    Hi Ninel..

    Based on your error message, it seems as though you might have an impersonation issue.  Check out this link in the latest BOL (web-posted on 21 July 2006):

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/18a64236-0285-46ea-8929-6ee9bcc020b9.htm

    Hope this helps!

    Take care..

    - Ward Pond
    blogs.technet.com/wardpond

  • August 29, 2006 at 12:22 pm

    #657335

    The link isn't working.

  • August 29, 2006 at 12:39 pm

    #657340

    Have you downloaded the July, 2006 BOL?

    Take care..

    - Ward Pond
    blogs.technet.com/wardpond

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply