• river1 - Monday, April 16, 2018 9:15 AM

    Now my problem is. I would not like that if Dataflow 1 fails that the package fails. Instead I would like to wait for the result of data flow 2 to give the package as failed.

    Can someone tell me how can I do this?

    Basically:

    If data flow 1 sucess then package sucess
    If data flow 1 fails move to data flow 2 but don't give the package as failed
    if data flow 2 fails give the package as failed otherwise (if sucess), as sucessfull.

    Thanks

    Change the value of the FailPackageOnFailure property on the DataFlow task to False.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk