April 12, 2018 at 6:19 am
It's been a few years since I've had the opportunity to do extensive SSIS work, so I'm a little rusty.
I have a situation in an existing package where I want certain actions to be taken based on the value of a project variable; "Full" file load versus "Differential" file load. Currently it only does the full file loads and my task is to add the ability to load differentials when available.
My boss' suggestion was to use a Conditional Split. Follow one path for "Full" and the other for "Differential". What I'm finding is that the Conditional Split only seems to apply to the task immediately following it, but still performs the tasks after that.
Anyway, I'm thinking I should step back to the Control Flow and use an expression on a Constraint with one Sequence Container for "Full" and another for "Differential".
Thoughts? Did I provide enough info?
April 12, 2018 at 6:30 am
kdbarrett 88655 - Thursday, April 12, 2018 6:19 AMIt's been a few years since I've had the opportunity to do extensive SSIS work, so I'm a little rusty.
I have a situation in an existing package where I want certain actions to be taken based on the value of a project variable; "Full" file load versus "Differential" file load. Currently it only does the full file loads and my task is to add the ability to load differentials when available.
My boss' suggestion was to use a Conditional Split. Follow one path for "Full" and the other for "Differential". What I'm finding is that the Conditional Split only seems to apply to the task immediately following it, but still performs the tasks after that.
Anyway, I'm thinking I should step back to the Control Flow and use an expression on a Constraint with one Sequence Container for "Full" and another for "Differential".
Thoughts? Did I provide enough info?
Conditional Split is the wrong option for this requirement. It applies only to rows flowing through a data flow.
You need to be using conditional logic in the Control Flow, as you have suggested, to force flow down the required path based on precedence constraint conditions.
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.
April 12, 2018 at 6:31 am
That's what I thought. Thanks for the sanity check!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply