I did get to work and I did remove the single quotes from my varibles, its my hotmail acount that needed verification.

Anyway I have a differnt problem I am trying to send emails using SSIS I have seen where scripting is required to do so since the Send DB Mail task has limited capabilities.

Do you know how this could be accomplished.

Please see my other post at

http://www.sqlservercentral.com/Forums/Topic1417996-364-1.aspx