asked on

Bulk Insert Error

Hello,

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

BULK INSERT [dbo].impPRODUCT_SUBS FROM '\\SQLSERVER\PumpData$\impFile.csv' WITH ( FIELDTERMINATOR = '|' ,ROWTERMINATOR = '\n' ,FIRSTROW = 1 )

any Ideas.

Thanks for the help

ASKER CERTIFIED SOLUTION

SjoerdVerweij

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Pletcher

CORRECTION:

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'

SOLUTION

Ken Selvia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nkjohnson

ASKER

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

nkjohnson

ASKER

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!

Ken Selvia

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.