Post reply

SSIS send mail task error out specified string not in form req for an email address

  • April 30, 2010 at 12:00 am

    #220106

    My send mail task works fine for email ids like user@mydomain.com but it throws error for email ids like user@subdomain.mydomain.com.

    is there any way i can make it work for such ids also?

    Thanks.

  • April 30, 2010 at 12:15 am

    #1160211

    What is the error it is throwing and is the error coming from the component or from the email server itself?

    CEWII

  • April 30, 2010 at 12:30 am

    #1160220

    Thanks for quick help.

    error msg is "specified string not in form req for an email address

    ".

    But i think the issue was different. I read email ids from csv file in 2 columns to and cc.In both columns i write multiple email ids with seperator ;.

    when i checked there was space between 2 email ids and that was causing error. So now i have task how I can trim the blank space in flat file source?

  • April 30, 2010 at 3:08 am

    #1160271

    Add a derived column after your flat file source.

    Use the following expression:

    REPLACE([Email_Address], " ", "" )

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 30, 2010 at 5:23 am

    #1160314

    Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply