asked on 5/17/2011

Unable to access destination table in SqlBulkCopy c#

when attempting to use SqlBulkCopy with c#, I am getting the following error;

'Unable to access destination table'

I have googled various documents that refer to using the table/schema name are set as appropriate and have tried the following options;

Tablename
Schema.Tablename
[Schema].Tablename
[Schema].[Tablename]
Schema.[TableName]

All with the same results.

The user I am logging on with has limited rights, but does have Insert allowed for the table. Although it may be something to do with permissions, the message is not very helpful.

Any pointers as a little stuck.

Thanks

C#Microsoft SQL Server

Last Comment

officedog

5/17/2011

Swindle

5/17/2011

Not sure if you even have the ability, but have you tried to manually insert something into the table? Also, you might try fully qualifying it [database name].[schema name].[table name]. It's possible your connection string isn't getting you to the appropriate database.

Krtyknm

5/17/2011

Did you try the below link? I hope it helps.

http://www.codeproject.com/KB/database/SqlBulkCopy.aspx

ASKER CERTIFIED SOLUTION

Paul Jackson

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

officedog

5/17/2011

ASKER

Will try adding the database identifier when I get back to the office, but I know for sure the connection string is correct as it is a global setting and the dev server currently only has that DB on it. The same connection string can is also able to run existing stored procedures.

Will also try adjusting the user permissions to allow select.

Will update when I have tried both.

Thanks

officedog

5/17/2011

ASKER

Added select rights to table and worked.

Thanks