"The command line parameters are invalid" error when running job from SQL Agent

Error :

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

While executing the Job in SQL Server Agent.

This is often a problem with parameter configuration, see e.g. here.

When you run from inside BIDS, you are in an environment where your parameters are available. When you schedule an SSIS package as a SQL Server job, those parameters have to come from somewhere. You can reference them in a configuration file, and you can override them in the configuration tab for the job.

Today I faced exactly same issue and I fixed it. What I did is, renamed connection name (without space, dots,hyphen) in my SSIS package. Previously I had default connection name so it showed error as

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

later I changed both source and destination connection names(without space) and used those packages while scheduling Job in SQL Server Agent and tried Start Jot at Step and succeeded.

I had a similar issue where the paramater value ended in a backslash. I just removed it and appended it back in an expression within the SSIS package.

Comments
  • what are you trying to do and with what ssis tools? what is the connections you are using? If you could explain the setup it would give a better indication.