none
Conditional Split Error

    Question

  • Hi Guys,

    Source Files - String Datatype

    Column0

     

    H, 1, 353474, 06, 52, 01, 01, 2009

    C, 4

    I, MV6106, 1, 3.85, , 3.85, R,  , 

    T, 65496, -0.35

    T, 1, 20.00

    H, 1, 353475, 06, 53, 01, 01, 2009

    C, 4

    Reference: Cashout_TX_353476

    I, 30159, 1, 1.00, , 1.00, R,  , 

    I, 458287, 1, 6.91, , 6.91, R,  , 

    I, 394085, 1, 2.15, , 2.15, R,  , 

    I, MV1293, 1, 2.80, , 2.80, R,  , 

    I, 132700, 1, 6.54, , 6.54, R,  , 

    T, 65496, -0.88

    T, 8, 19.40

    H, 1, 353476, 06, 53, 01, 01, 2009

    C, 4

     

     

    I am using condition split to get only H rows. There might be more than one H, So I need to make sure I am take fist H of the string.

    SUBSTRING([Column 0],1,FINDSTRING([Column 0],",",1) - 1) == "H"

     

    Error:

     

     

    [H ROWS ONLY [54]] Error: An error occurred while evaluating the function.

     

    [Conditional Split [54]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. 

     The "component "Conditional Split" (54)" failed because error code 0xC0049067 occurred,

     and the error row disposition on "output "HRows" (63)" 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.



    Any help much appreciate.

    Thanks,

    D

     

    Friday, October 22, 2010 3:03 AM

Answers