Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Update command taking long time to execute Expand / Collapse
Posted Tuesday, August 26, 2008 2:30 AM


Group: General Forum Members
Last Login: Wednesday, January 28, 2009 10:48 AM
Points: 15, Visits: 97
I am using update command under OLEDB command transformation to update existing records but it is taking long time to update mearly 10000 records. Why it is so. ?

Post #558675
Posted Tuesday, August 26, 2008 5:18 AM



Group: General Forum Members
Last Login: 2 days ago @ 11:56 AM
Points: 7,508, Visits: 8,664
The OLE DB Command in Data Flow works on a Row By Row basis. RBAR at its finest. @=)

If you have something huge to update, you're better off trying to figure out how to accomplish it in an Execute SQL Task. What I do is read my data into a Staging table with the Data Flow, then run an Execute SQL Task and, depending on the situation, either use the Execute SQL Task to upload the data to the final destination or return to a second Data Flow to finish my transformations.

Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog:
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #558745
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse