ForEach Container

Last Post 06 Aug 2008 04:40 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

04 Aug 2008 04:50 AM
I am trying to get the count of the items that the foreach container is either going to loop through or has looped through. If the count is zero, I want to then do something, like send an email to myself stating that there were no files to process that day. I am trying to use an event on the PostExecuteTask of the for each container. But I am getting stuck on just how to do this. I know there is a property called ForEachItems.Count. But not really sure how to set that value into a variable. Any help would be appreciated.
New Member
New Member

06 Aug 2008 04:40 AM
This is the related Microsoft page:

Let us know if helpful.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS:

Acceptable Use Policy