Job failure on RunSSIS package step

• Panks-913490

  SSCrazy

  Points: 2131

  More actions

  August 27, 2009 at 12:20 am

  #135696

  I have a job which runs an SSIS package as a step.

  Now this job is failing with a weird error.

  A part of job script where I think the error is generated:

  EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'RunSSISPackage',

  @step_id=1,

  @cmdexec_success_code=0,

  @on_success_action=1,

  @on_success_step_id=0,

  @on_fail_action=2,

  @on_fail_step_id=0,

  @retry_attempts=0,

  @retry_interval=0,

  @os_run_priority=0, @subsystem=N'SSIS',

  @command=N'/SQL "\MVR PRUBOND" /SERVER RGTHEPSQL36/MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E',

  @database_name=N'master',

  @flags=8,

  @proxy_name=N'Datamart_Console'

  The Error description goes like

  SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option " -1 " is not valid. The command line parameters are invalid. The step failed.

  Can some one please help

  Thanks

  Pankaj

• Andy Leonard

  SSChampion

  Points: 10144

  More actions

  August 27, 2009 at 11:43 pm

  #1046052

  Hi there,

  Just eyeballing this, I'd say you need a space before the "/MAXCONCURRENT" switch.

  Hope this helps.

  :{> Andy

  Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics