Home Forums Data Warehousing Integration Services Help Converting Case Statement to SSIS Expression RE: Help Converting Case Statement to SSIS Expression

  • May 18, 2015 at 9:53 am

    #1798684

    Something like this:

    ISNUMERIC (Left (DESIGN_NO,1)) = 0 ? DESIGN_NO : ( ISNUMERIC (Left (DESIGN_NO,5)) = 1 ? Left (DESIGN_NO,5) : Left (DESIGN_NO,4) )

    The syntax may not be 100% correct, but there should be enough there to get you started.

    John