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 16, 2018 at 9:37 am

    #1986994

    river1 - Monday, April 16, 2018 9:09 AM

    Thank you very much.

    I guess I found a cool solution that I would like to post here.

    I have created two connections, one called "ResColumn" and Other "WithoutResColumn"

    Then I have created for each a data flow.

    Basically when the first one fails (meaning that the file has NO res column ) I send the flow to execute the other data flow.

    So on failure of flo1 move to Flow 2

    😉

    Cheers

    The better solution (IMO) is to have a first step which checks the file to determine whether it contains the troublesome column & set a Boolean package variable accordingly, and then to use precedence contraints to control which DF gets executed.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.