Result set as an email message?

Question

Result set as an email message?

Amith Vemuganti

Ten Centuries

Points: 1350
More actions
November 23, 2009 at 9:09 am

#100696

Hello All,
I have a DTS package which exports the result set to an excel sheet and email it to the users using SMTP Mail task. I'm wondering if I can achieve this by sending the result set in email message body instead of a spreadsheet. Please advise.
Thanks,
-Amith Vemuganti

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 1

not exactly what you're looking for, but my favorite way to email result sets is via Reporting Services subscriptions. very easy to read on mobile phones as well

Amith Vemuganti Ten Centuries Points: 1350 More actions · Answer 2

I'm actually looking for my DTS package being able to send the result set, pulled by a SELECT statement inside the ExecuteSQL package, in an email with SMTP mail task to the users. I'd appreciate if some one could give me a solution or an idea on how I can do it.

Thanks,

-Amith Vemuganti

Old McDonald SSCertifiable Points: 5768 More actions · Answer 3

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'ProfName',

@recipients = '',

@query = 'SELECT 1,1,1,1,1',---specify your select query here

@subject = 'SUB',

@attach_query_result_as_file = 0 ;

The result of query will go in the body of the mail.

-Vikas Bindra

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 4

vikas bindra (11/25/2009)
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'ProfName', @recipients = '', @query = 'SELECT 1,1,1,1,1',---specify your select query here @subject = 'SUB',
@attach_query_result_as_file = 0 ;
The result of query will go in the body of the mail.

Where is the Excel file being created here? The OP wanted an excel file to have the results and send that excel in email.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Old McDonald SSCertifiable Points: 5768 More actions · Answer 5

Bru Medishetty (11/25/2009)
vikas bindra (11/25/2009)
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'ProfName', @recipients = '', @query = 'SELECT 1,1,1,1,1',---specify your select query here @subject = 'SUB',
@attach_query_result_as_file = 0 ;
The result of query will go in the body of the mail.
Where is the Excel file being created here? The OP wanted an excel file to have the results and send that excel in email.

I think he doesn't want the spread sheet. check his first post.

Hello All,
I have a DTS package which exports the result set to an excel sheet and email it to the users using SMTP Mail task. I'm wondering if I can achieve this by sending the result set in email message body instead of a spreadsheet. Please advise.
Thanks,
-Amith Vemuganti

Either of us got it wrong:-)

-Vikas Bindra

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 6

I am confused now...:-)

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Old McDonald SSCertifiable Points: 5768 More actions · Answer 7

Old McDonald

SSCertifiable

Points: 5768

November 25, 2009 at 8:07 am

#1084059

Lets wait for his reply.:Whistling:

-Vikas Bindra

Amith Vemuganti Ten Centuries Points: 1350 More actions · Answer 8

Vikas/Bru, Thanks for responding!

Yes. I don't want the result set in spread sheet or any other file. I want the result set to be sent in email message body. Unfortunately, I don't see sp_send_dbmail and xp_sendmail extended stored procedures in my msdb or master databases.

Thanks,

-Amith Vemuganti