I am trying to execute an SSIS package as a scheduled job. It runs fine when I store the connection string in a config file, but it fails when I store the connection string in an environment variable. Any idea why this is happening?

The account the Agent is running under has no rights to access the env. variable. Thus use a proxy account to run the ssis step. http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/Arthur My Blog