xp_cmdshell/DTEXEC in SSIS

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Hennie7863

    xp_cmdshell/DTEXEC in SSIS

    Hi,

    I'm not quit sure what the problem is but hereby a description about
    the symptoms i've seen:

    Situation
    I have a stored procedure Start_DTSX which executes DTEXEC in a
    xp_cmdshell. When i execute a dtsx package with this it wil work ok.
    But when i execute a package also with a Start_DTSX stored procedure it
    will not execute. The step is green but nothing has happened.

    Example

    Package A:
    START_DTSX anpackage.dtsx

    Package B
    START_DTSX Package_A.dtsx

    Could it be something like child/parent processes? any help
    appreciated..

    gr
    Hennie

Working...