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:40 am

    #1629800

    Hi Phil, Thanks for the speedy response

    i have rewritten the expression as follows:

    replace([precis],"~","")

    but am still seeing the error msg pasted below.

    There seems to be a problem with the input column not being in the input column collection.

    But Precis does appear in the column options in the derived Column transformation Editor.

    Is it possible that I'm using the derived colum trnasform in tha wrong place in my package DFT?

    TITLE: Microsoft Visual Studio

    ------------------------------

    Error at Data Flow Task [Derived Column [628]]: Attempt to find the input column named "precis" failed with error code 0xC0010009. The input column specified was not found in the input column collection.

    Error at Data Flow Task [Derived Column [628]]: Attempt to parse the expression "replace([precis],"~"," ")" failed and returned error code 0xC00470A2. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

    Error at Data Flow Task [Derived Column [628]]: Cannot parse the expression "replace([precis],"~"," ")". The expression was not valid, or there is an out-of-memory error.

    Error at Data Flow Task [Derived Column [628]]: The expression "replace([precis],"~"," ")" on "input column "PRECIS" (719)" is not valid.

    Error at Data Flow Task [Derived Column [628]]: Failed to set property "Expression" on "input column "PRECIS" (719)".

    ------------------------------

    ADDITIONAL INFORMATION:

    Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------