CODEWITHSUNDEEP
sql-serverssis
Simon GIS
Simon GIS

Reputation: 1055

SSIS Conditional Split does not contains part of a string

I have this table in my SQL Server:

ID    inn_name 
--------------------------------------
1     VITAMIN C(ASCORBIC ACID) + ZINC
2     Phosphore
3     AMOX + ACID + VITAMIN D
4     Sirop

In SSIS, I want to use conditional split to redirect all the names without 'VITAMIN' (ID 2 and ID 4)

So I'm trying to use this function to redirect the name without 'Vitamin' in conditional split.

FINDSTRING (inn_name, "VITAMIN", 1) != 1

Conditional Split SSIS

I tried many things but its still not redirect them. How could I fix this? Does this redirect only if the full row contains VITAMIN?

Upvotes: 0

Views: 1454

Answers (1)

KeithL
KeithL

Reputation: 5594

i think you want to check if it is >0.

https://learn.microsoft.com/en-us/sql/integration-services/expressions/findstring-ssis-expression?view=sql-server-ver15

FINDSTRING (inn_name, "VITAMIN", 1) > 0

Upvotes: 1

Related Questions