SQLTeam.com | Weblogs | Forums

SSIS Conditional Split help

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)

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

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

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

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.