I thought I share this with you, before you waste time like I did. If you are planning to deploy an SSIS with "Package Configurations" enabled using XML file, and if one of the dynamic properties is the "ConnectionString", you MUST add the "Password=xxx...