SQL Server Performance

Log in or Sign up

sending logfile as email attachment

Discussion in 'SQL Server 2005 Integration Services' started by Harnath, Jan 16, 2009.

Harnath New Member

Hi All,
I have some query regarding sending the package logfile as email attachment.
The scenario is i have a log file (text file) which will be created dynamically with datetime as filename. Now i need to send that logfile
in the email as attachment regardless of the package status (success/failure).
Any help is really appreciated.

Harnath, Jan 16, 2009

#2
satya Moderator

Are you using DBmail or CDOSYS - Reference to the CDOSYS objects are at the following MSDN Web site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_messaging.asp fyi.
declare @Comment Varchar(1000)

EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', @Comment out,'C: emp_ip.txt'

satya, Jan 17, 2009

#3
Harnath New Member

Hi Satya,
Iam using SMTP server,..

Harnath, Jan 18, 2009

#4

(You must log in or sign up to reply here.)

Share This Page