Stan Kulp-439977 (4/10/2013)
Our DBA went with the dtexec method with a config file.
That's how you're executing it, not deploying it, yes? At my organisation we don't "deploy" at all. Maybe I'm missing something fundamental, but I don't see the value in deploying a package either to MSDB or to the SSIS package store.
Instead we just keep packages and configs on a fileshare and execute them using SQL jobs. The only constraint this imposes is that we use windows authentication on our connections. It's extremely simple, flexible, easy to support and rapid to deploy. It's not highly secure, but security operates at 2 levels - file ACL and database security.