Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ash1807
Starting Member
10 Posts |
 Posted - 2015-03-12 : 07:41:37
|
| I am running a set of SQL statements on a SQL server, to insert flat file data into a SQL table. The flat file is already FTP'ed to the SQL server. I seem to be getting an error, which is possibly pointing to a permissions issueThe statements:BULK INSERT [Jedox_prod].[dbo].[B_BP_Customer]FROM 'c:\jedox_daily\jdcom4401.txt'WITH( FIRSTROW = 2, MAXERRORS = 0, FIELDTERMINATOR = '|', ROWTERMINATOR = '\n' ) GOThe error is :Msg 4861, Level 16, State 1, Line 1Cannot bulk load because the file "c:\jedox_daily\jdcom4401.txt" could not be opened. Operating system error code 3(failed to retrieve text for this error. Reason: 1815)If it is permissions issue, how do I overcome this?Ash Gajjar |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-03-12 : 08:34:30
|
| possibly a permissions error. 1. How are you running the BULK INSERT command? (e.g. from SSMS, from a Sql Agent job, from an SSIS package? from the command line via SQLCMD?)2. depending on your answer to the first question, ensure that the user running the BULK INSERT command has read permissions to the source data. |
 |
|
|
|
|
|
Bulk insert; permissions issue?