Maximum Value of String Variable?

  • Hi All,

    Does anyone know the maximum value of the string variable in the variables section? I have seen forums stating it can take up to 4000 characters and more but I am bringing in a list of mail recipients for a report and it will only list the first 255 characters from the package configuration XML file into the To: field in the Send Mail Task.

    Thanks

    Elliot

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • ...okay - After some reading I see that the To: Cc: and Bcc: fields are limited to 256 in line with internet standards.

    PS. I know people may think that posts like this are from people trying to work out how to spam but sometimes they really are genuine questions, as in this case.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

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

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