August 13, 2009 at 1:09 am
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
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.
August 13, 2009 at 9:11 am
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.
August 14, 2009 at 6:55 am
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