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 - 2005-10-05 : 07:21:34
|
| Andrew writes "I'm reading email and importing attachments with xp_readmail. It's a simple process I haven't had problems with until now. One email had multiple attachments, and I get a semicolon-separated list of the temp locations of these files. These temp filenames seems to be the first 8 characters of the attachment, followed by its extension. The email in question has two attachments with the same prefix and extension, but different suffix. xp_readmail is correctly finding two attachments, but the list contains two copies of the same name.For example, the email has attachments named:VIPorders092105b.csvVIPorders092105.csvAnd the @attachments parameter from xp_readmail has:C:\DOCUME~1\sqlagent\LOCALS~1\Temp\VIPorder.csv;C:\DOCUME~1\sqlagent\LOCALS~1\Temp\VIPorder.csvSo when I read the email and process the attachments, I get the same file twice. This seems to defeat the point of generating temp locations. How can I get the two distinct attachments?My server is running Windows 2000 SP4, SQL Server 2000 SP3, and Outlook 2000 SR1.- Andrew" |
|
|
|
|
|
xp_readmail, multiple attachments, non-distinct temp names