2008 R2.

I have been trying to get it to use dontsavesensitive and pass it creds. But my problem seems to be around the connectionmanager. If it deviates from the connections in the package, it seems to fail. That kind of kills the idea of deploying to lot's of servers.

Mine is slightly more complicated because these are executing against an Azure database. Azure treats each database as a new connection. Thus my requirement to be able to specify the connection at runtime. This is very frustrating.