September 20, 2010 at 10:10 am
I am trying to send the 15 MB file as an email attachment. but failing.
Is there any other options to send like file sharing or FTP. any thoughts?
Thank you.
September 20, 2010 at 11:50 am
More details on the error message, please.
September 20, 2010 at 1:52 pm
No error. I could see the mail in sent box.But client is saying he is not getting any email or attachments.
Client also they tested several files with
large attachments (up to 19MB) from both a Internal account and from a gmail account. All of the e-mails went through.
Not sure what is the issue here?
September 20, 2010 at 3:11 pm
If it is an issue with the size of the file you are attempting to send via email, you can always use a 3rd party application that splits it into more managable chunks.
I have used filesplitter for years.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 21, 2010 at 6:09 am
Have you tested the email without the attachment? Used DBMail manually in SSMS?
September 22, 2010 at 9:41 am
Brandie Tarvin (9/21/2010)
Have you tested the email without the attachment? Used DBMail manually in SSMS?
Yeah I have tested DBMail without the attachment. Every thing looks good.
THing is Client server is not able to receive even 10 KB rar file, even I tried with rename the extension to .aaa
They are successfully receiving excel, csv, text file attachments.
Is there any other option to send the production data report to client.
Like Temparary FTP site? not sure what will be the process to do that?
Please advice. Thank you.
September 22, 2010 at 11:50 am
Ahh. The client you're talking to is not the administrator of his mail server, is he? I bet .rar files are blocked from passing through.
If you haven't already, you need to get your email admin and his email admin both involved in the issue. Your admin to make sure the blocking isn't happening after the email gets to the mail server, his admin to make sure the blocking isn't happening there. Another way to verify your server is really sending the attachment is to send it to yourself.
You could fake a .rar file and send it to one of your external email addresses as a test, since the client is external.
As far as FTP processes go, you're asking the wrong people. SSIS has an FTP task, but you need to speak to your network admin and his network admin to get FTP set up. Yes, it can be done. But you need other admin's cooperation to get it done correctly.
September 28, 2010 at 1:30 pm
Client is using UNIX plotform.
Our OS is windows.
I tried internally from my end. I am able to send rar files(rename extension also) to myselft and my gmail account.
Client also confirmed the same that he can able to send/receive the files internally.
is it issue with the UNIX ?
September 28, 2010 at 1:34 pm
If you can send .RAR files to gmail, then you can send the files. If the client doesn't get them, perhaps their mail system is blocking a .rar file. That is configured on each mail server.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 29, 2010 at 4:35 am
I agree with Steve. This is an issue with the mail server on the client's end.
You say he's able to send .rar's internally, but has he actually tested receiving them from an external account (besides you)? Have him set up a GMail or Yahoo account and send his work address a dummy .rar file. I bet it gets stopped at his mail server.
And remember, FTP is different from email. FTP uses a completely different port in the company firewall. So if you want to FTP a file rather than email it, his company has to burn a hole in their firewall and give you IP and Port address information, not to mention login and password, in order to place the file on their system.
September 29, 2010 at 6:19 am
You might consider a service like box.net where you can upload the file and they can download it. They have a limited free memebership that should work in this situatuion. There are other ones out there as well.
MJ
September 29, 2010 at 6:49 am
Is box.net compliant with state and federal HIPAA & SOX laws?
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply