February 20, 2019 at 1:54 am
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.
February 20, 2019 at 7:55 am
It never ceases to amaze me how many people think that the error message is irrelevant to resolving an error.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy