xp_cmdshell and dtexec.exe

• JimWeber

  SSChasing Mays

  Points: 609

  More actions

  December 29, 2009 at 1:36 pm

  #143851

  I have an SSIS package being executed by xp_cmdshell on a Windows 2003 x64 machine. When I execute the SSIS package it will fail on an Execute Process Task. The execute process task is executing a vb exe program. I get the following:

  Code: 0xC002F304

  Source: Execute AcctSync Batch Execute Process Task

  Description: An error occurred with the following error message: "%1 is not a valid Win32 application".

  I have other steps in the package that execute sql tasks just fine. The command is below.

  exec xp_cmdshell 'C:\"Program Files"\"Microsoft SQL Server"\90\DTS\Binn\dtexec.exe /file "\\dob-sqlp1\SSIS Packages\acctsync.dtsx" /De password'

  It also fails when I run it on the server in a cmd window without xp_cmdshell such as:

  C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn>dtexec.exe /file "\\dob-

  sqlp1\SSIS Packages\acctsync.dtsx" /De password

  Does anyone know why this would be happening?

  I can run the package in BIDS successfully but it seems not with dtexec.