December 28, 2012 at 4:17 am
i set :
order : 1
Output name : Case 1
Condition : [EmpID] !=0
i got error :
===================================
Error at Data Flow Task [Conditional Split [30]]: The data types "DT_WSTR" and "DT_I4" 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 [Conditional Split [30]]: Attempt to set the result type of binary operation "EmpID != 0" failed with error code 0xC0047080.
Error at Data Flow Task [Conditional Split [30]]: Computing the expression " [EmpID] !=0" 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 [Conditional Split [30]]: The expression " [EmpID] !=0" on "output "Case 1" (79)" is not valid.
Error at Data Flow Task [Conditional Split [30]]: Failed to set property "Expression" on "output "Case 1" (79)".
(Microsoft Visual Studio)
===================================
Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.SetOutputProperty(Int32 lOutputID, String PropertyName, Object vValue)
at Microsoft.DataTransformationServices.Design.DtsSplitterComponentUI.SetOutputAt(Int32 index, ColumnInfo outputInfo, String expression)
at Microsoft.DataTransformationServices.Design.DtsSplitterComponentUI.SaveExpressions(ColumnInfo[] outputs, String[] expressions, ColumnInfo elseBranchName)
at Microsoft.DataTransformationServices.Design.DtsSplitterFrameForm.SaveAll()
December 28, 2012 at 4:54 am
It seems your EmpID column is a string column instead of an integer column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 28, 2012 at 7:31 am
You can use a Data Conversion component to convert the WSTR column to I4.
Thomas LeBlanc, MVP Data Platform Consultant
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply