Post reply

Derived Column Error Help

  • February 21, 2011 at 7:25 pm

    #232428

    Hi guys,

    Here is my sample data listed below

    ADDRESS

    san diego ca 91211

    los angles ca 93455

    my target field has city,state,zip

    i am using this expression in derived column transformation to parse address

    City:

    REVERSE(SUBSTRING(REVERSE(ADDRESS),(FINDSTRING(REVERSE(ADDRESS)," ",2) + 1),LEN(ADDRESS) - FINDSTRING(REVERSE(ADDRESS)," ",2)))

    State:

    TRIM(REVERSE(SUBSTRING(REVERSE(ADDRESS),FINDSTRING(REVERSE(ADDRESS)," ",1),(FINDSTRING(REVERSE(ADDRESS)," ",2) - FINDSTRING(REVERSE(ADDRESS)," ",1)))))

    Zip:

    REVERSE(SUBSTRING(REVERSE(ADDRESS),1,(FINDSTRING(REVERSE(ADDRESS)," ",1) - 1)))

    Here is error that i am getting:-

    [Derived Column [47]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (47)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "city" (60)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Derived Column" (47) failed with error code 0xC0209029 while processing input "Derived Column Input" (48). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

    I tried to fix this problem but no luck. Please help me out where i am wrong. I appreciate your help.

  • February 22, 2011 at 12:38 am

    #1289709

    Hi Rockey,

    Your expression looks good. No problem in that.

    I had encountered same kind of error before and it might be coming because of data type mismatch b/w source & destination. Please check your source as well as destination datatype and size.

    For verifying your output datatype you can open the advance editor for Derived Column transformation & check the output column data type for each column.

    Let me know if it helps.

    Thanks

    Anjan

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply