In my Data flow task i need to select certain rows which are matching my criteria.
The criteria requires using wild card characters like Field1 = '%aaaa%' or Field1 = '%bbbb%' ......
Field2 = '%aaaa%' or Field2 = '%bbbb%' ......
There are 6 fields ( Field1.. Field6 ) that have to be compared against values from a table ( aaaa,bbbb,ccccc etc from table)
FindString is not a option.
Any help will be appriciated!
View Complete Post