I am using an SSIS string variable and have since found out that this problem is a bug that has been fixed in SP1, However, SP1 introduced another bug that...

I also contacted a Microsoft evangelist and he will forward the problem to the proper support team for action.

Thanks for the reply. I moved the package to a Server with no SP and it worked.