Conditional Split Function Error
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.
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
October 22nd, 2010 2:12am
just put this rahul:
SUBSTRING([Coluumn 0],1,1)=="H"
Tweet me..
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 2:23am
- Thanks Sudeep
October 22nd, 2010 2:27am