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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-02 : 08:09:52
|
| Jorge writes "Hi everybody, actually I have a Java Application using MS SQL Server 2000 on Windows 2000 Server, within a Store Procedure I have the next sintax:select @SQL_Bulk_Insert = "bulk insert watchlist.dbo.wl_selectee from " + @Archivo_Selectee'Archivo_Selectee' is a parameter of entrance for the Store and it is varchar[100] type.During the execution of the application and debugging, the bulk insert sentence is of the following way... before executing itself:bulk insert watchlist.dbo.wl_selectee from 'c:\tsa_selectee_2006-n323_02-13-06(7).txt'After executing the Store Procedure, the application sends the next error:Server: message 4860, level 16, status 1, line 1 cannot insert massively. The file 'c:\tsa_nofly 2006-n323 02-13-06(7).txt' does not exist.And I'm sure that the file exists!What's could be happening or what's wrong??Jorge A." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-02 : 08:30:59
|
| Make sure whether the file exists in the Server where your SQL Server is installed and not at the local system you are usingMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Error using BULK INSERT command