SSIS package fails when Package Configuration is enabled using XML

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" yourself into the string. The Wizard won't store it.

Good luck

 

--tolga

Published Wednesday, April 29, 2009 5:18 PM by kemaltolga

Comments

No Comments

Leave a Comment

(required) 
(required) 
(optional)
(required)