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...
[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