http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

SSIS Package in SQL Server Agent Job Fails

Error:

Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

Solution:

If your SQL Server is 64 bit

In SQL Server JOB-->Properties-->Steps--->

In the Execution Option Tab -- Check "Use 32 bit runtime"

In the Data Sources Tab -- Uncheck the checkboxes of the connection managers if already checked.

Schedule the Job and run it.