Home Forums SQL Server 2005 SQL Server 2005 Integration Services Derived Column to handled mulitple conditions in CASE statement? RE: Derived Column to handled mulitple conditions in CASE statement?

  • May 30, 2013 at 7:09 pm

    #1619945

    Vikash, Phil, somebody?

    [Business Unit] is MFMGOOGLE and I want just the 'GOOGLE' part.

    This parses in the Derived Column transformation but isn't working as intended:

    SUBSTRING([Business Unit],4,LEN([Business Unit]) - 3)

    How to fix this expression to return intended result?