Post reply

execute process task fails

  • June 4, 2014 at 8:06 am

    #289509

    Hi All,

    I upgraded a package from DTS to SSIS 2008 r2 which includes one Script task and two execute process tasks

    Flow is below:

    First Script task

    second AAA execute process task which runs command file from folder (C:\NewFolder\AAA.cmd)

    Third BBB execute process task which runs command file from folder (C:\NewFolder\BBB.cmd)

    when I run task AAA is getting failed but task BBB getting success. When go to C drive right click on AAA.cmd run as administrator which is successfully running.

    But BBB.cmd running successfully from SSIS package.

    I have admin right to the folder. where as Task BBB is running successful with just a click or from ssis package but Task AAA failing to run, but both are in same folder.

    Please suggest.

    Thanks,

    Venkat

  • June 4, 2014 at 8:18 am

    #1718849

    What do the cmd files do?

    Please post the text of the error message.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 4, 2014 at 8:35 am

    #1718862

    It's only a copy command inside this cmd file.

    " Error: 0xC0029151 at ReportsToUsers, Execute Process Task: In Executing "C:\NewFolder\AAA.cmd" "E20070815" at "", The process exit code was "1" while the expected was "0".

    Task failed: ReportsToUsers"

    Regards,

    Venkat

  • June 4, 2014 at 11:29 am

    #1718922

    venkat5677 (6/4/2014)

    It's only a copy command inside this cmd file.

    " Error: 0xC0029151 at ReportsToUsers, Execute Process Task: In Executing "C:\NewFolder\AAA.cmd" "E20070815" at "", The process exit code was "1" while the expected was "0".

    Task failed: ReportsToUsers"

    Regards,

    Venkat

    This means that SSIS isn't the problem, it's the AAA.cmd component. In SSIS Execute Process, you can have it fail if it doesn't return a particular value, and that particular value is defaulted to 0. 1 or greater is usually an error.

    So, either turn that option off if you want to ignore the error, have it consider 1 a success, or have the .bat script EXIT 0 if it is sucessful.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • June 4, 2014 at 11:33 am

    #1718923

    .. you could also consider using a File System Task for doing the copy.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 5, 2014 at 2:50 am

    #1719116

    Can you please let me know where I can turn off options to consider 1 as success

    Thanks In Advance,

    Venkat

  • June 5, 2014 at 2:58 am

    #1719117

    venkat5677 (6/5/2014)

    Can you please let me know where I can turn off options to consider 1 as success

    Thanks In Advance,

    Venkat

    You should set SuccessValue to 1.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply