Result set as an email message?

Question

Post reply

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

alen teplitsky

SSC-Dedicated

Points: 30014

November 25, 2009 at 6:51 am

#1083967

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

Amith Vemuganti

Ten Centuries

Points: 1350

November 25, 2009 at 7:20 am

#1083993

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

Old McDonald

SSCertifiable

Points: 5768

November 25, 2009 at 7:42 am

#1084024

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

Bru Medishetty

SSC-Insane

Points: 23606

November 25, 2009 at 8:03 am

#1084053

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

Amith Vemuganti

Ten Centuries

Points: 1350

November 25, 2009 at 9:06 am

#1084135

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