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
What are the options for doing this? What is the best way?
Craig Bryden - Please mark correct answers
View Complete Post