Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL SSIS : How to pass the value of two arrays into a variable RE: SSIS : How to pass the value of two arrays into a variable

  • April 17, 2018 at 6:35 am

    #1987124

    Thom A - Monday, April 16, 2018 9:20 AM

    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.

    Thank you very much for your reply. I cannot do that because both flat file sources are in the same data flow. So what I have is:   One SSIS package with two connections, one named WithResColumn and the other named WithoutResColum. Then, inside the same data flow I have two flat file sources. One pointing to one connection and the other positing to the other. Both flat file sources connect to the same UNION ALL task. I would like that if one fails the other would continuo. Problem is that, If one of the flat file sources fails, then , even the other succeding , the data is not passed from the union all onwards. What can I do?