SSIS Conditional Split Not Working as Expected

Asked Jan 22 '21 at 02:26

Active Jan 22 '21 at 10:35

Viewed 23 times

I have the following Conditional Split set

Not Posted :  O_Variance != 0 && O_L_Revenue_nSAP == 0
Need Investigating : O_Variance != 0 && O_L_Revenue_nSAP != 0
Posted : O_Variance == 0

And everything is going to Posted even when the condition isn't meet and I have no idea why.

edited Jan 22 '21 at 10:35

Amira Bedhiafi

asked Jan 22 '21 at 02:26

Geoff Codd

What is the priority in each condition in your configuration? – Amira Bedhiafi Jan 22 '21 at 10:41
The order as listed above – Geoff Codd Jan 22 '21 at 11:44
what is the source of your data and what type are O_Varience and O_L_Revenue_nSAP ? – Amira Bedhiafi Jan 22 '21 at 14:18
Data is from OLE DB with some derived columns etc, the Data Type for those fields is numeric – Geoff Codd Jan 22 '21 at 14:59
Can you show your flow and detail what are you doing in each component so we can help you – Amira Bedhiafi Jan 22 '21 at 15:04

0 Answers0