Buffer tweaks are advanced methods. What is the design of the package. That kind of tasks are you using? What is source? What is destination?Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Source :- Excel File Destination :- db table Task : derived table,conditional split,source and destination... this design package not that much tough one.. its simple package only,but in olede commend task only take more time to update

OLEDB command is one of the costly transformation in SSIS... I don't think that you can improve your package performance much with this.... looks like you want to do the incremental load for your data .... check this if it helps you here... is there any possibility that you can use "execute SQl task" for this update ... (Not sure abt your requirement) let us know your observation... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Shall any one tell how to change buffer size in SSIS

Thanks

It won't do you ANY GOOD. That's what we're trying to tell you. You need to architect out your OLE DB Command. What statement is in the OLE DB Command? Talk to me now on

Hi i create a package in SSIS by using that package i want to load more than 2 lakh data but my package is loading too slow,How to Increase speed up SSIS package,all are in Google suggest to increase buffer size in SSIS,but i dont knw how to change that in SSIS..Give me some idea to change Buffer size in SSIS

Buffer tweaks are advanced methods. What is the design of the package. That kind of tasks are you using? What is source? What is destination?Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Source :- Excel File Destination :- db table Task : derived table,conditional split,source and destination... this design package not that much tough one.. its simple package only,but in olede commend task only take more time to update

OLEDB command is one of the costly transformation in SSIS... I don't think that you can improve your package performance much with this.... looks like you want to do the incremental load for your data .... check this if it helps you here... is there any possibility that you can use "execute SQl task" for this update ... (Not sure abt your requirement) let us know your observation... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Shall any one tell how to change buffer size in SSIS

Shall any one tell how to change buffer size in SSIS select your DFT and go to the property and change it.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Thanks

It won't do you ANY GOOD. That's what we're trying to tell you. You need to architect out your OLE DB Command. What statement is in the OLE DB Command? Talk to me now on