Update command taking long time to execute

  • 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. ?

  • 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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply