Charmer (9/21/2012)
Koen Verbeeck (9/21/2012)
Could have been anything. Syntax is probably correct, otherwise it would have errored out.Maybe a deadlock or something?
I am the only one who is using this table..i can say this database even...so i believe dead locking is not going to be the reason...but it is having 11 million records to be updated...Koen, is that one of the reason?
11 million records? Dump the OLE DB command and use a staging table. Unless you like waiting for a few hours for your package to finish.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP