Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 using 'between' in Conditional Split condition

Author  Topic 

mgreen84
Yak Posting Veteran

94 Posts

Posted - 2015-02-03 : 10:16:14
How can I use a between logic in a Conditional Split? I'm trying to use the following but it's giving me a error.

[id] >26337808 and [id] <=52675616



Error: Attempt to parse the expression "[id] >26337808 and [id] <=52675616" 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

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-02-03 : 10:26:22
In the Expression Editor, open the Operators menu. You should see that 'and' is not an operator. IIRC the operator you want is &&
Go to Top of Page

mgreen84
Yak Posting Veteran

94 Posts

Posted - 2015-02-03 : 12:16:15
quote:
Originally posted by gbritton

In the Expression Editor, open the Operators menu. You should see that 'and' is not an operator. IIRC the operator you want is &&





ahh, thanks!!
Go to Top of Page
   

- Advertisement -