File attachment or query results size exceeds allowable value of 1000000 bytes

Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes.

Send mail task in a DTA package failed with the below error attaching a .csv file of 3MB.

File attachment or query results size exceeds allowable value of 1000000 bytes

Resolution:

Open Database Mail Configuration Wizard.
Go to the “Select Configuration Task” window; Select the last option to the bottom “View or change systems parameters” and click Next.
“Configure System Parameters” window pops up, modify the “Maximum File Size(Bytes)” Parameter to your need. 10000000 (~10MB) did the trick for us.

This entry was posted in Database Mail, SQL Server, Troubleshooting and tagged , . Bookmark the permalink.

Leave a Reply