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 - 2002-02-12 : 09:11:08
|
| Tesh writes "Hi,I am running SQL server 2000 and just setup SQL mail. It is working fine. I can read a message and send a message. My problem is that I am not able to process the attached file.The attached file is either in Excel or csv format. 1. When I run xp_readmail, I am getting the following fully qulified file names. 'C:\DOCUME~1\sqlmail\LOCALS~1\Temp\Person_I.csv'Following the above I run the bulk insert comand.exec master..xp_readmailBULK INSERT #ImportTable FROM 'C:\DOCUME~1\sqlmail\LOCALS~1\Temp\test.csv' With ( Firstrow = 2 )when I ru the above I will get the following errors-------------------------------------------(1 row(s) affected)Server: Msg 4860, Level 16, State 1, Line 13Could not bulk insert. File 'C:\DOCUME~1\sqlmail\LOCALS~1\Temp\test.csv' does not exist.Am I doing it on the right sequence or do I need to follow special procedudres. I am running the the above from the server where SQL server sits on." |
|
|
|
|
|
Processing attachements (SQLMail)