From where is the package called?

If the SSIS package is called from a SQL Agent job you will need a proxy account to access the SSIS subsystem.

The article below explains what to do.

http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/[/url]