ForEach Container

Last Post 06 Aug 2008 04:40 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
stevoid1970
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.
SQLUSA
New Member
New Member

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

http://msdn.microsoft.com/en-us/lib....100).aspx

Let us know if helpful.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy