Avatar of PeterErhard
PeterErhard

asked on 

conditional split transformation editor

Can anyone see why this Condition won't work?

http://www.files2net.com/files/161362108/conditional_split_transformation_editor.JPG

This is the error I'm getting:


TITLE: Microsoft Visual Studio
------------------------------

Error at Data Flow Task [Conditional Split [483]]: Attempt to parse the expression "[Closed] == "Y" and [Date Closed] >=  DATEADD( m,-1,getdate() )" failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis.

Error at Data Flow Task [Conditional Split [483]]: Cannot parse the expression "[Closed] == "Y" and [Date Closed] >=  DATEADD( m,-1,getdate() )". The expression was not valid, or there is an out-of-memory error.

Error at Data Flow Task [Conditional Split [483]]: The expression "[Closed] == "Y" and [Date Closed] >=  DATEADD( m,-1,getdate() )" on "output "Case 2" (823)" is not valid.

Error at Data Flow Task [Conditional Split [483]]: Failed to set property "Expression" on "output "Case 2" (823)".
Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
PeterErhard

8/22/2022 - Mon