Post reply

String variable & CR/LF

  • November 25, 2009 at 7:30 am

    #139596

    Hi, I have a SSIS package that manipulates a string variable to construct a message. The problerm is my CR/LF pairs go missing.

    Basically a string variable is declared at the package level.

    An SQL Task poulates an object variable with a result set. The result set is iterated through a For Each container. Inside the For Each container the string variable is read in to a Script task together with variables mapped to the result set. Each iteration builds up the string variable into an email message. The message incluudes CR/LF pairs (vbCrLf). When the email is received the CR/LF's are missing.

    The problem seems connected to one particular variable from the result set. It is an NVARCHAR data type.

    Has anyone seen anything similar? got any ideas?

    Thanks

    Allen

  • November 25, 2009 at 12:54 pm

    #1084294

    [font="Comic Sans MS"]

    Hi Allen,

    I think you have already checked this by writing the message in a flat/text file. If you are getting CR/LF properly there - you might need to tweak the email reader (outlook/notes) setting..

    I did face a similar problem long back where an email sent from unix was not being displayes on outlook.

    [/font]

    [font="Comic Sans MS"]--
    Sabya[/font]

  • November 26, 2009 at 2:33 am

    #1084490

    Thanks Sabya, yes tried that. It seems to be when concatenating string variables in the vb script.

  • March 2, 2011 at 10:12 pm

    #1293845

    Hi,

    A simple way there is.

    Choose: In place holder properties->Mark up type->HTML

    then write HTML code,it works nice

    To go to the New Line just use <br />

    😀

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

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