locked
Linebreak in Send Mail Task SSIS RRS feed

  • Question

  • Hi All,

    I'm using below expression under Send Mail Task for Expression Builder Tab:-

    "Total Number of Source Records = " + (DT_WSTR, 10) @[User::TotalRecordCount] + 
    "\nPackage Start Time = " + (DT_WSTR, 20)  @[System::StartTime]

    When I evaluate expression statements are printing correctly with newly(\n) but when I receive email everything is printing in one SINGLE line.

    So my question how to split into multiple lines in receiving emails too.

    Any ideas

    Thanks

    Regards,

    Kumar

    Wednesday, March 24, 2010 12:07 AM

Answers

  • giving \n\n (TWICE) worked for me

    Thanks

    Regards,

    Kumar

    • Marked as answer by gk1393 Wednesday, March 24, 2010 11:03 AM
    Wednesday, March 24, 2010 2:30 AM
  • If you're using Outlook, it may be removing "extra" line breaks from your emails to "help" you read them.


    Todd McDermid's Blog
    • Marked as answer by gk1393 Wednesday, March 24, 2010 11:03 AM
    Wednesday, March 24, 2010 6:17 AM

All replies

  • giving \n\n (TWICE) worked for me

    Thanks

    Regards,

    Kumar

    • Marked as answer by gk1393 Wednesday, March 24, 2010 11:03 AM
    Wednesday, March 24, 2010 2:30 AM
  • If you're using Outlook, it may be removing "extra" line breaks from your emails to "help" you read them.


    Todd McDermid's Blog
    • Marked as answer by gk1393 Wednesday, March 24, 2010 11:03 AM
    Wednesday, March 24, 2010 6:17 AM