March 20, 2008 at 10:12 am
I'm having some trouble with a new SQL 2005 Server. Database mail is configured/enabled. I've used SSIS to create a package that exports data to an Excel spreadsheet and e-mails the file to a user (currently, me).
The Send Mail Task will send a message with the file attached from SSIS while debugging the package but once the package is compiled (no errors compiling) and executed from a job, I don't get the mail message. SQL Server Agent reports successful completion of the job.
I decided to add the Send Mail step as an Execute SQL Task which calls the sp_send_dbmail proc. I can send mail with the attached file from Query Analyzer using sp_send_dbmail. It sends the message successfully in debug mode within SSIS as well. However, once compiled and deployed, it fails to send the message when called from a job. Again, SQL Server Agent reports successful completion of the job but the e-mail never comes.
MSSQL and SQL Server Agent are running under a domain account that is a local admin and member of the sysadmin role.
sp_send_dbmail is using a public profile in Database Mail.
Any ideas?
Thanks!
March 20, 2008 at 11:01 am
do u know how to set that in ssi bcoz i tried doing it i couldnt get that ...
i have got error saying sending mail failure.....
i have addes smpt from data flo task in smtp what i gave the ip address of my server i am using now and given the rest of the details but i couldnt know what is the problem how can i know the ip address of smtp and where can i see the statu os port 25 and window blocker ..etc.....plz let me know i m new to ssis ...srry abt thi smay be it would be basic for u
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
March 24, 2008 at 9:56 am
I never got this to work within the SSIS package by either using the Send Mail Task or by including a Exec SQL Task which called the sp_send_dbmail proc.
I found a way to work around this. I simply dropped the step from the package and added a step to my job to send the e-mail. Step 1 in the job executes the package I created and Step 2 in the job picks up the file created by the package and e-mails it.
I'm still concerned that this isn't working as it's supposed to work. Any feedback would be appreciated.
-Kevin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply