Hi All, I am using SSRS and SSIS to complete task every day. I've SSRS report which generates the PDF invoice and SSIS process which saves the report and send it to the email as attached pdf and body of email. It runs fine. But couple of times, I got request to check the format because it adds many non-usable texts like DNuxuVE8hdeH2M3aZ3DIC8lPNU1TDJ6idxCy0y9otVOajQBhD3NfsxFzB53PUJM0TfUwbsfo ' and 1000 lines with some random text. it doesn't happen to all emails. I BCCed myself for couple of days. and I got it without no problem. I set body of email in html format in Stored procedure and set it as column field and insert that into table. it's bit critical and complex system i had to make. but it works fine for almost 99% of emails. please let me know if its known issue or anyone knows the solution. also please let me know if you've any questions. Thanks in Advance, Cool Mind

You will need to narrow this down to specifics as who is getting those emails with the garbled text and if they are all the same. My whild guess it has something to do with the page encoding.Arthur My Blog

We're sending an invoice as pdf attachment to customer. When I BCCed myself with all those emails, I found no issue with any of the emails. and most of the time, customer dont find any problem. but i got couple of inquiries that they're not able to open the PDF. and the text they're getting was all garbled text as I showed in my Original post.

There is something special about these users. E.g. a different version of Adobe or no porper encoding/font etc installed. Try to get more info on differences between your machine and the user machine. There is a difference in size may be or something. It also does not seem to be SSIS related, correct?Arthur My Blog

I agree with you and I'm thinking the same. That if its SSIS issue, it should give me the same format of email. Another thing, when customer forwarded the email back to us, the attachment was Subject name with rtf format. That's so strange. Attachment should be PDF file. So now looking into rtf format. it must be at customer side. I will keep posting here when I get some updates. Thanks for all your time...

Does that happen to other users too?Arthur My Blog

that was just one. Others got the garbled text. but the ratio of getting this type of email is less than 1% we got to know only when they inform us by contacting our team

I have an idea: send such a user the attachment that you had no issues with, see what the other end gets.Arthur My Blog

I would like to check the network, the mail server too. Or, we can save every copy of the attachment locally, and when the issue occurs, check if the local copy is fine the moment. This will help to isolate the issue. Thanks, Jin ChenJin Chen - MSFT