I have a SEND MAIL TASK in a package that I want to dynamically set the PRIORITY property. In EXPRESSION BUILDER I have to return an integer value so based on what I have used in .NET I was expecting that NORMAL = 0, LOW = 1, HIGH = 2. When testing in SSIS however, I find that a value of 0 or less sets it to NORMAL and a value of 1 or higher sets it to HIGH. I can't seem to find a value to set LOW. :crazy:
Does anyone know what the appropriate values are for setting the priority for Exchange Server emails in an SSIS expression?
Thanks in advance...