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 - 2003-10-27 : 08:08:43
|
| James writes "Can I create a dts package that calls a store proc and emails the results from the stored proc into the subject area of the email.Right know I can execute a stored proc in a DTS package and sending out a notification(email) that 'process has completed.'" |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-10-27 : 09:54:42
|
| One suggestion would be to store sp results in table and query results table using ado in DTS. |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2003-10-27 : 10:00:19
|
| Either ADO or sp_OACreate can do this for your. There is an example of using the SMTP COM object 'CDONT.newmail' object to send out email from an sp.Daniel Small MIAPwww.danielsmall.com IT Factoring |
|
|
|
|
|
|
Use DTS to email result of a stored proc