I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ and also do not allow the use...

Thanks Site Owners,

What I would like to have happen is for the "FailPackageOnFailure" to actually cause the package to fail and stop running/exit when the error occurs.  Some data flow...

I work in the same type of environment (DEV/TEST/PROD) and do NOT use SQL Server to store any part of the package, only files (eg: .dtsx, .dtsConfig) checked in to...

Try creating the config file without any of the connection information being exported to it.  Then, when running dtexec, use the /SET \Package.Connections[MyConfigConn].ServerName;My2005Server format for setting the connection information. 

Also,...

Try this:

In the package properties, go to Security/ProtectionLevel and select EncryptSensitiveWithPassword.  Then enter a password above that in PackagePassword.  You will need to pass the password in when you run...