<div>
Thanks for passing this along Reza<br />
<br />

</div>


<div>
Glad to help,<br />
Regards,<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi guys, <br />
<br />
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.<br />
<br />
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 :<br />
<br />
Email Data Send Mail Task<br />
&nbsp; &nbsp;Description: An error occurred with the following error message: &quot;Exceeded storage allocation. The server response was: 4.3.1 Message size exceeds fixed maximum message size&quot;.<br />
<br />
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?<br />
<br />
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?<br />
<br />
Thanks<br />
<br />
Regards,<br />
<br />
Vinay
</div>
</div>


Hi guys, 

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?

Thanks

Regards,

Vinay

SSIS 2005 Zip files

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.