SSIS scheduling 32bit dtexec.exe as SQL job step

• Stuartb113

  SSC-Addicted

  Points: 440

  More actions

  November 7, 2007 at 5:11 am

  #118802

  Hi, I am trying to schedule the 32bit dtexec.exe to run a package on the file system.

  Is it possible to use the SSIS Package job type and edit the command line?

  I've tried but when I edit the 'Command Line' i.e.

  c:\"program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /FILE /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

  After OK and exiting the command line entry is restored to the original options

  i.e. /FILE /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

  If it is not possible what is the way to run the package as 32bit. Operating system (CmdExec) I suspect but please confirm

  thanks,

• Stuartb113

  SSC-Addicted

  Points: 440

  More actions

  November 7, 2007 at 6:59 am

  #749083

  CmdExec is the way to go. Found this post explaining all.

  http://support.microsoft.com/kb/934653