command line parameters are invalid in SQL server Agent

Hi

Microsoft confirmed that the error message "The command line parameters are invalid" issue mentioned above is a bug and has been resolved in the next "drop" of SQL Server 2005.

has this error been fixed by microsoft. Cos i still get this error!!!!!!!!!

I am also trying to run the package from command line and when i click on execute the package it runs half way and hangs. What could be the problem?.

But when i run it from my Studio and stored package it works fine!!!

Thanks,

Jas

Perhaps the command line is incorrect. You do appear to have some keys that stick on your keyboard, which could lead to typing invalid commands.

Seriously, we need some more information to help you. What command line parameters are you trying to set?

Your second issue probably needs another thread. We would need to know what the package does - what tasks execute and what it is doing when it hangs.

Donald

|||

I have created a job to execute a SSIS package located in the SSIS Package Store. When starting the job I receive an error. The history log reports:

Message
Executed as user: semaster\vagnel. The command line parameters are invalid. The step failed.

I did not write this command line it is auto generated through wizard.

This is the command line:

/SQL "\ArchiveMain" /SERVER "SE413695\AASQL2005" /WARNASERROR /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

Thanks,

Jasmine