I was trying to send a mail via SSIS using the smtp server of windows server 2008, when I got the following error:
“Exceeded storage allocation. The server response was: 4.3.1 Message size exceeds fixed maximum message size.”
To fix this problem, you have to do the following:
Open IIS 6.0 Manager, expand your computer’s name, scroll down to the SMTP server, right-click it and select “Properties” from the context menu.
Click the “Messages” tab and set a maximum message size. Alternatively you could allow any size messages by deselecting the “Limit message size to (KB):” checkbox.