There is nothing else going on that specifically requires me to do it that way other than that's the only way I know to get the information back out. This is my first experience with ADO.net connections. In my case, performance is not a big deal since the table is less than 1000 rows. What would be a better way to approach the problem? Create and populate a temp table in the Data Flow and then use the execute sql task to do the update? I appreciate the advice.