This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 30%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond twice when you send an email to an OOF user.
Anyone have fix for this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
If one of those users has "out of office" set, the SSIS flow fails.
Please edit your question, and add the error message as text.
At the moment, its a difficult thing to test because it always works the 2nd time you run it and the job runs via SQL Agent. I'll need to run manually. Setting myself as out of office doesnt work either. I'll setup a log to capture the errors and send.
Hi @Mark Lewin,Once you get the log, you may attach here.
Here's the error. Its saying that the email is formatted wrong, but its not. I've outputted the email list and verified multiple times. It fails once when there is an Out of office set, then when i run it again, it runs fine. Its a mystery! It only fails when one of the recipients are out of office.
Microsoft (R) SQL Server Execute Package Utility
Version 13.0.5026.0 for 64-bit
Copyright (C) 2016 Microsoft. All rights reserved.
Started: 9:00:01 AM
Error: 2024-03-28 09:00:04.74
Code: 0xC002F304
Source: Send Mail Task Send Mail Task
Description: An error occurred with the following error message: "Syntax error in parameters or arguments. The server response was: 5.1.6 Recipient addresses in single label domains not accepted [BL6PEPF0001AB4A.namprd04.prod.outlook.com 2024-03-28T13:00:04.725Z 08DC46748F048F51]".
End Error
I have verified that all emails are correct and no odd emails are set into the "send mail task". I have a failure flow that sends me an email showing the email list. Always ok and if i run job again right after failure, it works fine. Just fails first time when a user has set his/her out of office.
Microsoft (R) SQL Server Execute Package Utility Version 13.0.5026.0 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved.
Started: 9:00:01 AM Error: 2024-03-28 09:00:04.74 Code: 0xC002F304 Source: Send Mail Task Send Mail Task Description: An error occurred with the following error message: "Syntax error in parameters or arguments. The server response was: 5.1.6 Recipient addresses in single label domains not accepted [BL6PEPF0001AB4A.namprd04.prod.outlook.com 2024-03-28T13:00:04.725Z 08DC46748F048F51]". End Error
I have a simple Send Mail Task
A "Send Mail Task" sends emails, it don't receive emails, so an out-of-office auto reply can't effect the SSIS task, it must have a different reason for the error; which you haven't mentioned in detail.