emailing an attachment from DTS

I have a DTS package that runs 4x a day and generates an excel spreadsheet, renames that spreadsheet with a datetime stamp and then places it into a folder on our network. I have been asked to email that spreadsheet to someone everytime the package runs.

My question is what would be the best way to handle this and how do I ensure that whatever process I define grabs the correct file? The folder that the Excel file is being placed into has multiple files in it. Is there a way to tell SQL Server which file to grab and email?

Any thoughts or suggestions would be greatly appreciated! Thanks!

Frank

You can use Gert's xp:

http://sqldev.net/xp/xpsmtp.htmsql

Email Validation in reporting Sevices...

Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?
ThanksIm using Reporting Server to send that...please any hints'sql

Email Subscription

Hi,

Please help, I am trying to setup email subscriptions using reporting services. When the subscription runs i get a status of Logon Failed.

What does this error mean?

Problem with the SMTP settings?
Problem with some background user settings?

Any info in the right direction welcome.

Si

Hi

What is the exact error message you received under the status column.

You can also look in the log file, it will be called ReportServer_(date).log under your server installation directory \logfiles.

Did you enter the right smtp address in rsReportServer.config (will be entered with installation but can be modified afterwards.)

StarBuck

EMail is blocked from subscriptions

When subscribing to a report, with email notification, the report runs on
schedule but the email is not delivered...the error "The transport error code
was 0x800ccc15. The server response was not available..." is displayed. We
have excluded DatabaseMail90.exe and ReportingServicesService.exe from the
option
â'Prevent mass mailing worms from sending mailâ' in the Mcafee virusscanner,
but it still gets blocked. I'm guessing we still haven't identified the
correct process. Any help would be appreciated.Look at the permissions of the "Unattended Execution" user in the "Report
Server Configuraiton" manager.
It needs more rights.
"Alchemist" <Alchemist@.discussions.microsoft.com> wrote in message
news:7FA15047-F258-47AF-A964-673A9467FC40@.microsoft.com...
> When subscribing to a report, with email notification, the report runs on
> schedule but the email is not delivered...the error "The transport error
> code
> was 0x800ccc15. The server response was not available..." is displayed.
> We
> have excluded DatabaseMail90.exe and ReportingServicesService.exe from the
> option
> 'Prevent mass mailing worms from sending mail' in the Mcafee virusscanner,
> but it still gets blocked. I'm guessing we still haven't identified the
> correct process. Any help would be appreciated.
>|||We didn't find an "Unattended Execution" parameter, but there is an
"Execution Account" parameter that appeared to be what you meant...but it
didn't work. We still get the "Failure sending mail: The message could not
be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available" error message. Seams the DB access is not
the issue, but getting to the SMTP server is. Is there something else we
could be missing'

Email delivery not functioning

I am trying to set up automatic email delivery on our production reporting
server which runs on version 1.0 with no service pack. I modified the
RSReportServer.config to make sure the SMTP server specification is correct.
The SQL server job created says it runs successfully. But no email ever
sent out. What could be wrong? And where can I find the log file that
recording this activity? Is it a SQL log?
Same set up has worked on my development machine, which has sp1 installed.
But I want to avoid installing sp1 on production unless I am sure that's the
cause.
-- XuefengLook for the log file name ReportServerService<date>.log file. It should be
located under \Program file\Microsoft Sql Server\ReportingService\Logfiles
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xuefeng Cao" <xcao@.massmed.org> wrote in message
news:OCgnvE8pEHA.3524@.TK2MSFTNGP15.phx.gbl...
> I am trying to set up automatic email delivery on our production reporting
> server which runs on version 1.0 with no service pack. I modified the
> RSReportServer.config to make sure the SMTP server specification is
correct.
> The SQL server job created says it runs successfully. But no email ever
> sent out. What could be wrong? And where can I find the log file that
> recording this activity? Is it a SQL log?
> Same set up has worked on my development machine, which has sp1 installed.
> But I want to avoid installing sp1 on production unless I am sure that's
the
> cause.
> -- Xuefeng
>

Email delivery failure

Has anyone had issues with emails being delivered? The job runs successfully,
but the email does not get delivered. It seems to be related to the Reporting
Services server and not the email server. The reason I believe this is that,
after I reboot the Reporting Services server, the emails are successful. I
haven't been able to determine what causes the blockage on that server.Correction: Has anyone had issues with emails "not" being delievered?
"Rand" wrote:
> Has anyone had issues with emails being delivered? The job runs successfully,
> but the email does not get delivered. It seems to be related to the Reporting
> Services server and not the email server. The reason I believe this is that,
> after I reboot the Reporting Services server, the emails are successful. I
> haven't been able to determine what causes the blockage on that server.|||I am having the same exact issue. Any luck? Can you provide input on how you
resolved your issue, if you did?
"Rand" wrote:
> Correction: Has anyone had issues with emails "not" being delievered?
> "Rand" wrote:
> > Has anyone had issues with emails being delivered? The job runs successfully,
> > but the email does not get delivered. It seems to be related to the Reporting
> > Services server and not the email server. The reason I believe this is that,
> > after I reboot the Reporting Services server, the emails are successful. I
> > haven't been able to determine what causes the blockage on that server.

Editing SQL Jobs

I have scheduled a T-SQL job that runs every morning using Enterprise Manager. Now I want to change the SELECT and UPDATE statements that this job runs, but I can't find anywhere to edit a job that has already been scheduled. Any help would be appreciated.

ThanksIn Enterprise Manager, under your SQL Server
-- expand the Management node
-- expand the SQL Server Agent node
-- click on Jobs
-- right-click on your job and choose Properties
-- click on the Steps tab
-- click on the desired Step and choose Edit...

Terri