Bulk Insert Error

Posted on 2004-08-12
Last Modified: 2011-08-18

I am currently trying to run a Bulk insert and I keep getting the following error.

Bulk_main: The opentable system function on BULK INSERT table failed. Database ID 1, name 'impPRODUCT_SUBS'.

The command is


any Ideas.

Thanks for the help
Question by:nkjohnson
  • 2
  • 2
  • 2
  • +1
LVL 18

Accepted Solution

SjoerdVerweij earned 150 total points
ID: 11788408
Try doing it from a local drive. If that works, you might need to map a drive letter to the UNC path.
LVL 69

Assisted Solution

ScottPletcher earned 25 total points
ID: 11788595
Make sure the 'select into/bulkcopy' option is set on for that db.  To check, use this command:

EXEC sp_dbOption 'yourDbNameHere'

If it's turned off (it doesn't display in the list), you can turn it on using ALTER DATABASE.
LVL 69

Expert Comment

ID: 11788656

BOL says to use ALTER DATABASE, but I don't see that as a valid option.

Use sp_dbOption instead:

EXEC sp_dbOption 'yourDbNameHere', 'SELECT INTO/BULKCOPY', 'TRUE'
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

LVL 12

Assisted Solution

kselvia earned 75 total points
ID: 11788674
The account SQL Server runs as probably does not have rights to the share.

Verify with;

master..xp_cmdshell 'dir \\SQLSERVER\PumpData$\impFile.csv'


Author Comment

ID: 11792156
You are right kselvia access was denied.  How do I go about getting access to the file?

Author Comment

ID: 11792773
Thank you all for your assistance.  I am going to divy up the points because all of you were actually correct.  

I was able to use the bulk insert if I referred to a local drive.  I have had problems with this before when creating Linked servers.  Does MSSQL 7.0 have problems refering to locations with network addresses?  Any last thoughs on this?  

Again thank you for your help!
LVL 12

Expert Comment

ID: 11793508
Change the SQL Server service to login as a domain account (My computer+Manage+Services+MSSQL Server) and grant that account rights to the share.


Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

914 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

23 Experts available now in Live!

Get 1:1 Help Now