March 12, 2009 at 5:34 am
Could not bulk insert because file 'C:\csvame.txt' could not be opened. Operating system error code 3(The system cannot find the path specified.).
hi i got the above error while insert bulk txt file. Previously i put c drive this file and got the error that "could not bulk insert.FIle "C:ame.txt" does not exist.
After that i gave sharing permission to the folder name csv and put the file name.txt. Now i got the above error.
Friends if you know any idea, tell me.
Hope yours reply.
March 12, 2009 at 5:43 am
hi thanks for your reply. so where i put the file and how can i insert bulk??
March 12, 2009 at 5:50 am
You need to put the file either on the db server or another server (UNC) which the db server can access.
In your case put it in the C drive of the machine in which sql server is running. Lookup BOL for more details.
"Keep Trying"
March 12, 2009 at 5:54 am
Bulk Insert in it's most basic form:
Create a temporary table that reflects the structure of the data you are inserting.
Place the text file you are importing onto a drive that is on the same machine that SQL Server is installed on.
BULK INSERT ##temptable
FROM 'c:\filename.csv'
WITH (FieldTerminator = '',
RowTerminator= ''
)
There's not a great deal to a basic Bulk Insert. BOL and this site should have plenty of examples.
March 12, 2009 at 6:08 am
yes i did.I put in the db server.
but i got same exception.
BULK INSERT checkcsv
FROM '\\IWAPPSVR\IWSQLDBame.txt'
WITH
(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')
March 12, 2009 at 6:09 am
hi i created ##tempTable also and check it. same exception occured.
March 13, 2009 at 1:16 am
BULK INSERT checkcsv
FROM 'C:\foldername\IWSQLDBame.txt'
WITH
(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')
Specify the correct drive where i have put "C:\" and put the correct folderpath in "foldername" and try.
"Keep Trying"
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply