Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of tesla764
tesla764

Invalid object name when doing a bulk insert.
When I run the code below, I get the error seen below the code. As far as I can tell _gpg_filenames is a valid object. I could be wrong. COuld some please help with this.
Thanks in advance.

code...
use Direxxis

BULK
INSERT _gpg_filesnames_test
FROM 'C:\Documents and Settings\sritsick\My Documents\jsr\Erie_Master\ErieTest\filelist_test.txt'
WITH
(
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
GO

messages...
Msg 208, Level 16, State 82, Line 3
Invalid object name '_gpg_filesnames_test'.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of Simone BSimone B🇨🇦

Is the name _gpg_filesnames or _gpg_filesnames_test ? You are using _gpg_filesnames_test
Avatar of tesla764tesla764

ASKER

I am using _gpg_filenames_test
I just noticed the "s" in filesnames. I changed that to filenames and get the following error...
Msg 4861, Level 16, State 1, Line 3
Cannot bulk load because the file "C:\Documents and Settings\sritsick\My Documents\jsr\Erie_Master\ErieTest\filelist_test.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).

This path does exist.
ASKER CERTIFIED SOLUTION
Avatar of Simone BSimone B🇨🇦

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of tesla764tesla764

ASKER

yes I am running management studio using windows authentication, no I am mbergman which should have all privs needed. I am testing this from the studio management query (New Query). I have looked thoroughly for typos. I can't find any.
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of Simone BSimone B🇨🇦

I'm running out of ideas, yet it still somehow seems an access or path issue. The machine you're using is a Windows OS version that uses "Documents and Settings?"
Avatar of tesla764tesla764

ASKER

I think this is a permissions issue. Thanks for your help.
Avatar of tesla764tesla764

ASKER

Thanks.
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.