Home Forums Data Warehousing Integration Services Creating derived columns from column of variable length components RE: Creating derived columns from column of variable length components

  • If I don't use (or attempt to use) the (DT_WSTR,3), then it gives me a 'The function "FINDSTRING" does not support the data type "DT_NTEXT" for parameter number 1. The type of the parameter could not be implicitly cast into a compatible type for the function. To perform this operation, the operand needs to be explicitly cast with a cast operator.' error...I'm thinking this hopefully will correct this error?