Is there a way to use IN using SSIS scripting instead of ==? For instance if(Row.blah IN (1,2,3,4,......) )
I have 65 codes to search and that many OR statements gets messy.
You can use a string compare.
Create a string of the codes you want to check ",1,2,3,4,5,"
Convert the value to a comma delimited string ",3," and check if it is in the codes string.