Ells (8/20/2014)
The lookup either feeds an insert or update OLEDB commands. With this data set I foresee a couple of million inserts on the new day, then regular small number of updates throughout the day but will wait and see.
Personally I would insert the updates in a staging table and do a single TSQL UPDATE statement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP