August 30, 2006 at 10:19 am
Hi,
I have a user with bulk admin system rights as well as INSERT, UPDATE, DELETE, SELECT on the target table. But I get "Server: Msg 8104, Level 16, State 2, Line 1
The current user is not the database or object owner of table 'staging.dbo.table_name'. Cannot perform SET operation.
When I issue a bulk insert command:
BULK INSERT staging.dbo.table_name
FROM 'C:\data_operations\Flat_File_Drop\mar_0606.txt'
WITH (
DATAFILETYPE = 'char' )
Any ideas? What SET operation is being performed here?
SQL 2012 Standard VPS Windows 2012 Server Standard
August 31, 2006 at 7:56 am
The user needs rights to run xp_cmdshell or you have to set up a proxy user for the SQL Agent.
August 31, 2006 at 9:47 am
Wait, I dont understand at all. What does xp_cmdshell have to do with a SET operation for bulk inserting? Can you explain the relationship please?
SQL 2012 Standard VPS Windows 2012 Server Standard
September 1, 2006 at 6:25 am
i think an easy way to do that is to use the "database owner's" credentials in the bulk uploading process.
i hope that will let you do the uploading ...
Ciao
FarriJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply