SQLTeam.com | Weblogs | Forums

SSIS Script IN

#1

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.

0 Likes

#2

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.

0 Likes