Monday, August 20, 2012

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--->

  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.



2 comments: