Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

SQL: SSIS Error When Sending Mail Through SMTP

Today, I came across this error, that occurred when running an existing SSIS package:

Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Syntax error in parameters or arguments. The server response was: 5.5.4 Invalid Address”

After lengthy investigation, I discovered that one of the email addresses that it was trying to send to, had single quotes around it.  Once I removed the quotes, the SSIS package ran through and completed successfully.

Leave a Reply

Your email address will not be published. Required fields are marked *

CJayMead's SQL Server, Endeca, MS Office Help © 2018