Stefan Krzywicki (5/13/2013)
Can you use SSIS?I've done something similar recently with SSIS, so if you can use it I think you have a good option.
Yes, we can use SSIS. In fact we're using SSIS to load the file into our staging table and run the proc that does the update.
I've got a few meetings, but after those I'll dummy up some data and sanitze the destination tables and post them in a bit.