I have a ssis 2005 package that retrieves data from SQL 2005 and populates various sheets within different excel spreadsheets and then emails this to different distribution groups.
The package runs fine and populates the necessay files. When trying to email one of these files, I get the following error from the Send Email task :
Email Data Send Mail Task
Description: An error occurred with the following error message: "Exceeded storage allocation. The server response was: 4.3.1 Message size exceeds fixed maximum message size".
I know that this is related to exchange and not SSIS. My DBA has increased the max size limits for sending mail for the user for which this package runs for, but to no avail. Is there something that I am missing?
Also, I am thinking that zipping these files before emailing them would be a better option going forward. Does anyone have any information detailing the steps that I need to follow when using the Execute Process Task to zip these individual files before emailing these?