Monday, August 20, 2012

SSIS Package in SQL Server Agent Job Fails

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


If your SQL Server is 64 bit

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

  1. In the Execution Option Tab -- Check "Use 32 bit runtime"
  2. In the Data Sources Tab -- Uncheck the checkboxes of the connection managers if already checked.
  3. Schedule the Job and run it.

1 comment: