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-12-11 : 09:16:54
|
| Alan writes "When we schedule a dts package which attaches a text file to an email and sends the mail, the mail is received but the attachment is not received in a readable format. The attachment is ok in the 'sent items' folder of the server. We are using sql 2000 (standard) on Windows 2000, the server has SP 2 installed.We have tried configuring outlook on the server but it doesnt seem to help." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-11 : 16:05:28
|
| What kind of an attachment is it: ASCII, Excel, Word...? Do you have the appropriate viewer? Have you tried running it using xp_sendmail instead of through DTS? Is the file readable when you open it from the server (meaning not from the sent items but rather from say Windows Explorer)? |
 |
|
|
|
|
|
attachments sent using sql mail as a job