• If no data is pushed along the output, the output will do no work. That is not to say that it won't be validated when the package fires, so there is a small overhead in having so many paths.

    A possible problem for you is where your input file suddenly contains durians and kumquats and you have not built the conditions for directing these new fruits into your conditional split. If you need this type of dynamic processing, a different approach is required.

    Regarding the double quotes - it's because SSIS is not based on T-SQL. The SSIS expression language is more like C# with some SQL-like functions added in. C# uses double quotes for string literals.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.