I am building an ssis upload into sql. the excel sheet tht I import contains multiple suppliers, but I only want to upload the data for certain suppliers. I have written this condition in a conditional split transformation
FINDSTRING(UPPER([Supplier Name]),"xxx",1) > 0 || FINDSTRING(UPPER([Supplier Name]),"yyy",1) > 0, However my package is failing if it only finds one of the conditions, ie some sheeets contain data from both suppliers, some sheets only contain data from one. i was under the impression that || is an or, so i cant work out why it is failing. would appreciate any help.