Home Forums Data Warehousing Integration Services How to use REPLACE in a Derived Column Transformation? RE: How to use REPLACE in a Derived Column Transformation?

  • July 4, 2013 at 4:14 am

    #1629793

    Try changing your expression - you do not need the 'select' bit. See here for reference.

    Also, note that literal text should be surrounded by " rather than ' in SSIS expressions.