The larger issue i am tackling is how to identify/update changed FACT table rows from incoming rows. I have gone through a lot of samples, Project REAL examples etc...the conclusion i came to was to use a Lookup transform and use the OLE DB Command task
to issue updates. Is this the right way to go?
Now specifically, when i do that, the DFT is taking an extremely long time to run through 250k rows. When i ran Profiler, i am seeing that the OLE DB Command is issuing an sp_execute for each row!
I would like to hear what i am doing wrong with my overall approach and specifically for this OLE DB Command?
View Complete Post