There is no direct alternative for patindex in the derived column. So you can either use a script component with .NET, or stick with SQL.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP