Making a year column by semester
hi! ok i`m trying it,as the same time I`m trying to make Grade column like we made GPAEQUIVALENT,but error occurs "(DT_STR,10,1252)([Marks] < 50 ? "F" : [Marks] )" TITLE: Microsoft Visual Studio ------------------------------ Error at Student_History_Fact [GPAEquivalentMarks [342]]: The data types "DT_WSTR" and "DT_I4" are incompatible for the conditional operator. The operand types cannot be implicitly cast into compatible types for the conditional operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator. Error at Student_History_Fact [GPAEquivalentMarks [342]]: Attempt to set the result type of conditional operation "Marks < 50 ? "F" : Marks" failed with error code 0xC004709F. Error at Student_History_Fact [GPAEquivalentMarks [342]]: Computing the expression "(DT_STR,10,1252)([Marks] < 50 ? "F" : [Marks] )" failed with error code 0xC00470A0. 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 Student_History_Fact [GPAEquivalentMarks [342]]: The expression "(DT_STR,10,1252)([Marks] < 50 ? "F" : [Marks] )" on "output column "Grede" (995)" is not valid. Error at Student_History_Fact [GPAEquivalentMarks [342]]: Failed to set property "Expression" on "output column "Grede" (995)". ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ mhassanshahbaz
December 12th, 2010 1:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics