Hi Phil,

Thanks for your quick answer.

Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it is the best option since use a "OLE DB Command" component is too slow.

I posted it here, because this issue is a part of an ETL proccess and I´m comparing loading strategies, but it could also be posted in the SQL Server 2008 forum.

Kind Regards,