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 - 2001-08-13 : 00:04:24
|
| Neil writes "I am running the following statement :BULK INSERT full_text_dump FROM 'e:\ngw\sample_files\sample.sql' WITH (DATAFILETYPE = 'widechar')This works fine and I have incorperated it into a Stored Procedure. However in some situations the file (ie e:\ngw\sample_files\sample.sql) may not exist. In this case the bulk insert statement fails with a fatal error. I would like to know how I can check if the operating system file exists prior to runing the Bulk insert statement so that I can avoid running the bulk insert and therefore avoid the fatal error.Please let me know if this is possible." |
|
|
|
|
|
Bulk Insert