Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
enable access to smtp from azure-ssis
![](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(83.2, 67%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Adila mebrek
25
Reputation points
I'm new SSIS dev.
I have created a script task that use a SendMailMessage function and call smtpClient.Send(message) to send an email.
While it is working locally, whenever I try to execute the SSIS package on azure data Factory wit IR Azure-SSIS it's not working.
FYI, my Azure-SSIS has a Public IP. and DB is in Azure also.
Can anyone help me please
Azure Data Factory
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
SQL Server Other
14,494 questions
{count} votes
-
![](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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,366 Reputation points Moderator2023-10-20T19:28:41.1166667+00:00 Hello @Adila mebrek Did you check SMTP server configuration regarding the firewall settings to allow traffic from the IP address of your Azure-SSIS integration runtime?
-
Adila mebrek 25 Reputation points
2023-10-21T20:14:18.2333333+00:00 yes, and I enabled the port 587
-
QuantumCache 20,366 Reputation points Moderator
2023-10-23T00:46:55.63+00:00 @Adila mebrek For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket, else could you please send an email to
-
ZoeHui-MSFT 41,491 Reputation points2023-10-23T01:25:46.2133333+00:00 Hi @Adila mebrek,
Could you provide the error message so that we could do more analysis.
-
Adila mebrek 25 Reputation points
2023-10-24T13:47:25.21+00:00 The error is only SendMessage Failed
-
QuantumCache 20,366 Reputation points Moderator
2023-10-24T18:43:35.4266667+00:00 Hello @Adila mebrek Did you get a chance to file a support ticket in this matter? If you need more help please see our previous response to send an email to us , so that we could help you!
We will do our best to help you out.
Firstly, it's great that you have enabled port 587 on your Azure-SSIS. However, there are a few more things that you need to check to ensure that you can send emails successfully.
Check if your SMTP server requires authentication. If it does, you need to provide the correct credentials in your SSIS package. You can do this by setting the
Credentialsproperty of theSmtpClientobject.Make sure that the SMTP server you are using allows connections from Azure-SSIS. Some SMTP servers may block connections from unknown IP addresses, so you may need to whitelist the IP address of your Azure-SSIS.
Check if there are any firewalls or network security groups that may be blocking outgoing traffic from your Azure-SSIS. You may need to configure these to allow outgoing traffic on port 587.
Verify that the SMTP server is configured to allow connections on port 587. You can test this by using a telnet client to connect to the SMTP server on port 587.
If you have checked all of the above and are still having issues, you may want to check the logs on your Azure-SSIS to see if there are any error messages that can help you diagnose the issue.
I hope this helps! Let me know if you have any further questions.
-
QuantumCache 20,366 Reputation points Moderator
2023-10-31T06:17:57.7333333+00:00 Hello @Adila mebrek Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!
Please click "Accept Answer" . So that we can close this thread.
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more