SQL Server Performance

DTS & xp_cmdshell & dtsrun

Discussion in 'SQL Server DTS-Related Questions' started by vlasto, Jun 11, 2004.

  1. vlasto New Member


    I have two simple DTS packages TestT and TestPkg. I run TestT from TestPck using Execute SQL Task. SQL statement is

    EXEC master..xp_cmdshell 'dtsrun /S (local) /E /N TestT'

    Problem is, that this task is always completed successfully. Even if TestT fails.
    I need to know if TestT fails a do some action (SendEmail). So how can I detect it ? Thanks a lot.

Share This Page