Hi I'm using SSIS 2008 I have a data flow that gets data from an Excel spreadsheet. It then does numerous lookups to my database to ensure that all the entities in the spreadsheet are present in my dimension tables. For each of these lookups, I redirect rows with "no matching entries" to be written to another spreadsheet which is then sent to an email address for action. I have a Package scoped variable that I want to update if any of the lookups have rows with no matching entries. This is used later in the package to determine if it should proceed or not. So this variable only needs to be updated once if any of the lookups fail. What are the options for doing this? What is the best way? ThanksCraig Bryden - Please mark correct answers

You can use a row count transformation and connect it to the error output of lookup component. Once the data flow task is complete, this variable contains the total number of rows that failed at that particular lookup. If you have more than one lookup, you have to use as many number of row count transforms.Nitesh Rai- Please mark the post as answered if it answers your question

Nitesh beat me to it. ;)

Thanks Nitesh I can see how that would work. I assume all the Row Count transforms can write to the same Variable? Craig Bryden - Please mark correct answers

Yes they can write to same or different variables.Nitesh Rai- Please mark the post as answered if it answers your question