Showing posts with label Server Agent. Show all posts
Showing posts with label Server Agent. Show all posts

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

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