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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-06-02 : 05:40:03
|
| Hi,I have recently migrated DTS Package to the new server (2k5) and some of the task has the capabilities to send mail on success/failure using "master.dbo.xp_smtp_sendmail". When i try to run the package in the 2005 environment, the SP is not available and subsequently failing.1. How to run the sp in 2k5 environment, where is the download path.2. or we need to use the xp_sendmail commands which is readily available in 2k5, if that is the case i need to identify each package and perform the changes, looks tedious.Thanks in advance. |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-06-02 : 08:53:40
|
| Though i download and copy the relevant dlls, Is xp_smtp_sendmail is compatible with the sql 2005 environment?Please advise. |
 |
|
|
baburk
Posting Yak Master
108 Posts |
Posted - 2009-06-02 : 09:00:55
|
quote:
Originally posted by carumuga
Though i download and copy the relevant dlls, Is xp_smtp_sendmail is compatible with the sql 2005 environment?Please advise.
It helped me to send mail.http://www.mssqltips.com/tip.asp?tip=1438 |
|
|
|
|
|
|
Extended procedure - Mail