In my SSIS package, I have "TF- Advanced Email and SMS Task 2020.18.1" controller. So I have a recipient that his email address is like below
Test.T'[email protected]
So when I'm sending email to above address, the "TF- Advanced Email and SMS Task 2020.18.1" controller truncate the email address before apostrophe (') and sending
So currently it is sending email to this kind of address
So it is truncating the first part of the email address before apostrophe sign. Really appreciate, if anyone can help me on this.
----Update---- I guess some work around need to do here. What I tried is manipulating the email address before passing to "TF-Advanced Email and SMS" controller.
Also I tried something like this
string ToEmail = "{Test.T'Est}"+"@testdomain.com";
ToEmail.replace('{',' ');
ToEmail.replace('}',''\');
''''
Then when I send a email through "TF-Advance Email.." controller, it will send a email to below address.
Test.T'Est'@testdomain.com
But the additional apostrophe will be there Also, **it cannot replace with current apostrophe**, like this ("Test.T{'}[email protected]" - this is not working)
So still **did not find any clue** on this.