Logical OR Condition in EvalExpression of a For Loop Container

If you double click on the For Loop Container of SSIS, a new window will open where you can set up the condition based on which the loop will continue. There is a field called EvalExpression where you can set an expression and if this expression holds true, the loop will continue. I was just wondering if it is possible to introduce an logical OR condition in that field. Just you have already thought, it takes pipes (||) to implement OR between two conditions. Hopefully, the below snapshot will be enough if you have any doubts:

 

Advertisements

About Zahid

Team Lead at IQVIA (www.iqvia.com). Fields of expertise are C#,BI Reporting (MSBI, Microstrategy, Excel, ASP.NET Dashboards etc.) , ETL, Data Warehouse, OLAP Cube, MDX etc.
This entry was posted in SSIS (SQL Server Integration Service). Bookmark the permalink.

One Response to Logical OR Condition in EvalExpression of a For Loop Container

  1. I solved this by using an Expression Task at the end of the flow in my For Loop Container to set the value of the package variable I use in the EvalExpression.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.