Sample Header Ad - 728x90

SSIS 2012 VS_ISBROKEN on Derived Column

6 votes
3 answers
2573 views
I have converted a SSIS package built in VS2008 to open in VS2010. I have a Derived Column component that fails validation. It works fine in VS2008. Here is the Expression used in Derived Column... FINDSTRING( SecurityDescription,"\n",1) > 0 ? SUBSTRING(SecurityDescription, 1, FINDSTRING(SecurityDescription,"\n",1) - 1) ) : SecurityDescription Below are the errors when I run the package... enter image description here Error is: >[Derived Column ] Error: Attempt to parse the expression "[FINDSTRING](#102,"\n",1) > 0 ? [SUBSTRING](#11898,1,[FINDSTRING](#11898,"\n",1) - 1) : #102" failed and returned error code 0xC00470A3. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error. I have double checked and SecurityDescription is a valid column. It works fine if I just add SecurityDescription. Not sure what is wrong with the FINDSTRING code.
Asked by K09 (1454 rep)
Jan 31, 2017, 12:34 PM
Last activity: May 6, 2017, 07:21 AM