in

ASP.NET Weblogs

Tolga Koseoglu

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

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add

About kemaltolga

Born in Ankara, Turkey. Raised in Germany. Recruited for the Track & Field Team at Texas A&M University in College Station, TX, in January 2000. NCAA champion in 2001 (Discus). Work for design firm in southern California. Married with two daughters.