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 IMS Health (www.imshealth.com). A part-time consultant and trainer. Fields of expertise are ETL, BI Reporting (Microstrategy, Excel, ASP.NET Dashboards etc.) 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s