Post reply

Problem with row by row update

  • August 13, 2009 at 1:09 am

    #385173

    I have a table with 300,000 rows where row by row update has to be performed. Use of an OLEDB command in Data flow task is a real pain on performance. Is there any way performance can be improved?

  • August 13, 2009 at 7:48 am

    #1038689

    ns.sharath (8/13/2009)

    I have a table with 300,000 rows where row by row update has to be performed. Use of an OLEDB command in Data flow task is a real pain on performance. Is there any way performance can be improved?

    Check the Batch Destination component. If you use SQL 2008, you can check the Merge Destination Component, which is based on the new MERGE statement.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • August 13, 2009 at 9:11 am

    #1038765

    perhaps if you provide a bit more information on what you're trying to do we might be able to suggest a better way of performing the update rather than row by agonizing row (RBAR). Check the first lin ki9n my signature for the type of information I'm talking about.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • August 14, 2009 at 6:55 am

    #1039287

    AS Luke has said if you provide us with some more specifics perhaps we can offer an alternate solution. It may be set-based solution or another way to work the problem in SSIS.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 4 posts - 1 through 3 (of 3 total)

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