Post reply

Formattting in Expression Builder

  • October 29, 2014 at 10:50 am

    #291451

    Hello Gurus,

    I Package that sends out an email to new users coming into our organization. In Expression builder is there a way to underline or bold some words?

    Thanks!

  • October 29, 2014 at 12:27 pm

    #1755617

    It looks like i will have to use a 'Script Task' to send a html email. How do i call a variable within the body of the message? for example this email will go out to different people and i want the greeting to be like "Dear [dtsVariable] , "

    Thanks,

  • November 6, 2014 at 2:10 am

    #1756898

    Ok,

    so not sure why you need to use a script task.

    I would use a send mail task. When you do that you can use a string variable for each of the email objects (to, from, subject etc) and when you edit the task on the Mail page there is 'message source type' that can be set top variable.

    So with this and using expressions you can send multiple emails the message variable will be created dynamically. Using a script task before the Send Mail task and this will allow you to expand on just sending the same mail.

    One word of warning - sometimes if sending data as well as a message you may wish to attach the file with the data as the size of the variables in SSIS is good but not good enough to contain pages of text. Think its around 4000 characters.

    Altering the message variable in Script task will allow you to customise the message

    Hope that helps.

    E

Viewing 3 posts - 1 through 2 (of 2 total)

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