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.