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 |
|
jamie_pattison
Yak Posting Veteran
65 Posts |
 Posted - 2008-10-09 : 04:35:00
|
| Is it possible to create an email task, that has the results from a database sent to a user. I think i need to use expressions under Send Email Task but can anyone give some guidance?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-09 : 05:32:11
|
| you can save the query results as a recordset to variable and then use that variable to map to message body of send mail task using expression builder. some think like below. you could use sent email task instead of script task in examplehttp://www.sqlservercentral.com/articles/SSIS/62678/ |
 |
|
|
|
|
|
Dynamic message in email body