August 15, 2015 at 12:38 pm
Comments posted to this topic are about the item SSIS Conditional Split Expressions
August 16, 2015 at 11:16 pm
This was removed by the editor as SPAM
August 17, 2015 at 6:02 am
And here starts the obligatory pedantry. 😛
In a conditional split transformation, an expression is evaluated for each row.
is not quite correct. The correct statement is:
In a conditional split transformation, one or more expressions are evaluated for each row.
Each expression returns true or false, and each expression is tied to a specified output. In this way, a single conditional split can divide a rowset into multiple sets, each of which can be processed distinctly.
August 17, 2015 at 6:03 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 17, 2015 at 6:05 am
sknox (8/17/2015)
And here starts the obligatory pedantry. 😛In a conditional split transformation, an expression is evaluated for each row.
is not quite correct. The correct statement is:
In a conditional split transformation, one or more expressions are evaluated for each row.
Meh, not convinced 🙂
The question says= "an expression is evaluated for each row". As the conditional split has to evaluate at least 1 expression, that statement is true. It just doesn't go into specifics if it is one or more expressions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 17, 2015 at 8:04 am
sknox (8/17/2015)
And here starts the obligatory pedantry. 😛In a conditional split transformation, an expression is evaluated for each row.
is not quite correct. The correct statement is:
In a conditional split transformation, one or more expressions are evaluated for each row.
Each expression returns true or false, and each expression is tied to a specified output. In this way, a single conditional split can divide a rowset into multiple sets, each of which can be processed distinctly.
Picky. Picky. Picky.
It doesn't change the answer, so, move on. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 17, 2015 at 8:05 am
I would have felt bad if I got this one wrong.
Good one to start the week with Steve.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 17, 2015 at 9:28 am
Probably slightly incorrect to say it's only one expression. It could be, but it could be multiple ones.
I'll change the question, but I'm not sure this affected the answers.
August 17, 2015 at 9:31 am
Steve Jones - SSC Editor (8/17/2015)
Probably slightly incorrect to say it's only one expression. It could be, but it could be multiple ones.I'll change the question, but I'm not sure this affected the answers.
Doesn't matter how you word it. Expressions still need to result in True or False.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 17, 2015 at 10:49 am
Alvin Ramard (8/17/2015)
Steve Jones - SSC Editor (8/17/2015)
Probably slightly incorrect to say it's only one expression. It could be, but it could be multiple ones.I'll change the question, but I'm not sure this affected the answers.
Doesn't matter how you word it. Expressions still need to result in True or False.
Agreed. The question is really fine either way; I just wanted to clarify that a single conditional split can use multiple expressions to generate several distinct outputs, as this is an incredibly useful feature which I have had to use recently.
August 17, 2015 at 12:19 pm
Nice - thanks, Steve!
August 18, 2015 at 12:34 am
Nice and easy. Thanks for sharing
August 18, 2015 at 3:35 am
Absolutely no idea abut this, so thanx 4 getting new info!
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
August 18, 2015 at 8:23 am
sknox (8/17/2015)
And here starts the obligatory pedantry. 😛In a conditional split transformation, an expression is evaluated for each row.
is not quite correct. The correct statement is:
In a conditional split transformation, one or more expressions are evaluated for each row.
Each expression returns true or false, and each expression is tied to a specified output. In this way, a single conditional split can divide a rowset into multiple sets, each of which can be processed distinctly.
Thanks for the clarification.
August 19, 2015 at 3:21 am
I almost got this wrong, because upon first reading of the question I thought this was about an execution plan operator.
Luckily, I remembered that the operator that the description would have applied to is called "Switch", not "Conditional Split". And then I read with more attention, noticed the SSIS in the title, and realized my mistake.
But this gave me an idea. Would people appreciate if I submit a few questions about execution plan operators? Or would that be too specialized/advanced?
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply