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.
lcarpay
SSC Veteran
Points: 271
More actions
September 6, 2013 at 8:32 am
#1648116
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