Home Forums SQL Server 2005 SQL Server 2005 Integration Services Argument "Server1" for option "connection" is not valid. The command line parameters are invalid. The step failed. RE: Argument "Server1" for option "connection" is not valid. The command line parameters are invalid. The step failed.

  • hi, the solution didn't work for me though I had the same error. What I found was that the SQL Connections (in BIDS) can not contain spaces when processed via the SQL Agent.

    - Leon