Other ways of doing bulk insert?

Posted on 2008-11-09
Last Modified: 2012-05-05
My hosting service has turned off bulk insert so I get this error if I try to run the following script:

Msg 4834, Level 16, State 4, Line 16
You do not have permission to use the bulk load statement.

Their suggestion is to backup the db to my local machine, do the insert and restore to the remote.  Is this really feasible or is there a better way?
create table #temp


symbolid int,

transactiondate datetime,

closingprice money



insert #temp

from 'O:\sso.csv'



                FIELDTERMINATOR = ',',

                ROWTERMINATOR = '\n'


insert into historicalprices.history (symbolid, transactiondate, closingprice)

select symbolid, transactiondate, closingprice

from #temp

drop table #temp


Open in new window

Question by:brettr
    LVL 142

    Accepted Solution

    if fear that is the only option, apart if you wanted to generate the INSERT statements themselves on your local db, and run them afterwards on the prod db

    Author Comment

    How do I generate the insert statements as you mentioned?
    LVL 67

    Assisted Solution

    You could try with

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now