Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 email attachment issue

Author  Topic 

cognos79
Posting Yak Master

241 Posts

Posted - 2009-01-08 : 11:36:34
I am trying to add an attachment to email using mailmessage class:

htmlMessage.Attachments.Add(New Attachment(Attachment_nm))

this one works correctly in dev environment, when I move it to prod there is an email but no attachment.

Did anyone had problems too using attachments with mailmessage class?

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2009-01-08 : 13:15:51
Check for proper file location of the attachment and its permission.
Go to Top of Page

cognos79
Posting Yak Master

241 Posts

Posted - 2009-01-08 : 13:34:09
the filelocation looks correct. if the ssis scheduler doesnt have permissions to the excel file then the package should fail, right instead of skipping the attachment smoothly.
Go to Top of Page
   

- Advertisement -