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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Email - cannot open excel attachment

Author  Topic 

theboyholty
Posting Yak Master

226 Posts

Posted - 2011-12-09 : 10:03:21
I've set up an SSIS package to send an excel file to a load of clients. What the clients receive is an email with an excel file attached. One client, who uses webmail and Firefox can't open the attachments.

They've sent me screenshots which show the email and the attachment with the .xls extension, and when they click on it the Open File dialog box comes up with the attachment showing as 'unknown_filename'. I've suggested saving it to a desktop but that's no better.

The really odd thing is, when we forward them a regular email with the attachment (as opposed to the SSIS automated email), they can open the attachment no problem.

Has anyone any ideas how to handle this as its getting right on my nerves now and the client is getting hacked off too.

Thanks,

Nick.

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk A Bury FC supporters website and forum

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-12-12 : 16:16:15
1. do they have excel?
2. Can you repeat this problem by sending the email with attachment to yourself?

If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -