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 |
|
msfoxy
Starting Member
2 Posts |
 Posted - 2007-08-02 : 19:10:34
|
| Hi,We have a DTS package in the old SS2000 that we are still using in SS2005. We change the old xp_sendmail to use the new sp_send_dbmail. This runs fine without attachment. But with attachment, I'm encountering an error when running the package. The task reported failure on execution.The client connection security context could not be impersonated. Attaching file requires an integrated client login. Syntax error or access violation.I cannot find much topic on the net about this error.Thanks very much for any help.Regards |
|
|
marktdavies
Starting Member
1 Post |
Posted - 2007-10-25 : 10:30:25
|
| I had a similar problem and changed the connection to use a windows account on the machine rather than a SQL Login. This then worked correctly .RegardsMark |
 |
|
|
|
|
|
Problem with sp_send_dbmail with attachment