SSIS Conditional Split help

SSIS and Import/Export
1

Error at Data Flow Task 1 [Conditional Split [1]]: The data types "DT_I4" and "DT_WSTR" are incompatible for binary operator "==". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.

Error at Data Flow Task 1 [Conditional Split [1]]: Attempt to set the result type of binary operation "FINDSTRING("10","[Core]",1) == "10"" failed with error code 0xC0047080.

Error at Data Flow Task 1 [Conditional Split [1]]: Computing the expression "FINDSTRING("10", "[Core]",1) =="10"" failed with error code 0xC0047084. The expression may have errors, such as divide by zero, that cannot be detected at parse time, or there may be an out-of-memory error.

Error at Data Flow Task 1 [Conditional Split [1]]: The expression "FINDSTRING("10", "[Core]",1) =="10"" on "Conditional Split.Outputs[Case 2]" is not valid.

Error at Data Flow Task 1 [Conditional Split [1]]: Failed to set property "Expression" on "Conditional Split.Outputs[Case 2]".

ADDITIONAL INFORMATION:

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

2

you are going to have to provide more than just posting errors.

3

sorry about that. thank you for replying. I have fixed this issue. Changed the datatype and length

4

Still not helpful. Please show us by screenshot or tell us what is the cause of the error?

5

Go to Advanced Editor for Derived Column>Input and Output Properties>Derived Column Output>Output Columns>select your column > under Data Type Properties> Change DataType and Length.

Hope that will help.