Home Forums Data Warehousing Integration Services SSIS: Calling dtsx using xp_cmdshell in SQL Server 2008- error on task - with Execute Process Task (error: "No process is associated with this object) RE: SSIS: Calling dtsx using xp_cmdshell in SQL Server 2008- error on task - with Execute Process Task (error: "No process is associated with this object)

  • December 20, 2013 at 2:08 pm

    #1675313

    The Executable Process Task is set up correctly. It runs successfully while running the SSIS package and command line.

    Executable Process task details in SSIS (this executable task is inside a ForEachLoop Container)

    Under Process Category (in Execute process task editor)

    Executable: Winzip64.exe

    Argument: -min -m -en "E:\SSISPackage\OUTPUT.ZIP""E:\SSISPackage\"

    Working directory: C:\Program~1\WinzipOutput: SSIS package run successfully manually.

    Code for Command Prompt is below:

    Code to use on cmd line: dtexec /f "E:\SSISLocation\Package.dtsx"

    Output: It is able to call the SSIS package successfully.

    Code run in SQL browser (it fails here - not prompting and creating the zip file:

    USE master

    Go

    DECLARE @ReturnCd AS INT

    EXEC @ReturnCd = xp_cmdshell 'dtexec /f "E:\SSISLocation\Package.dtsx:'

    Output: It is not running... It doesn't create the zip file and move all the files in the directory into the zip file. I get the error shown in my message. Any ideas?