Hi All, I have a SSIS Package which contains DataFlow Task is having OLEDB Source(Configured Oracle server) and OLEDB Destination(Configured SqlServer). Almost 14 Crores of data there in source table. I have ran almost 15 hrs back, it has brought 4 crores of records yet. I did small modifications of with respective to DataFlowTask Properties of BLOBTempStoragePath,BufferTempStoragePath, DefaultBufferMaxRows(Defalut is 10000 is changed to 1000),DefaultBufferSize(Calculated of Estimated size of each row data* DefaultBufferMaxRows=49bytes*1000=50176000) and accessmode of OLEDB Destination to Operrowset using Fastload. Iam not finding any difference in the performance after changing these properties. Could you please Suggest me how to proceed in this scenario. Thanks & Regards, Anil

are you using the standard oracle provider or the one from attunity? http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Hi anil yaaram, There are couple of articles you can check out, this will get your job done: 1. http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ 2. http://msdn.microsoft.com/en-us/library/ms141031.aspx 3. http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/85f79025-7521-4c81-84ce-3c39db63859f 4. http://consultingblogs.emc.com/jamiethomson/archive/2006/03/14/SSIS_3A00_-Data-flows-or-T_2D00_SQL.aspx 5. http://siddhumehta.blogspot.sg/2010/05/ssis-performance-testing-measurement.html Thanks, Khilit http://www.bigator.com

Hi anil yaaram, There are couple of articles you can check out, this will get your job done: 1. http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ 2. http://msdn.microsoft.com/en-us/library/ms141031.aspx 3. http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/85f79025-7521-4c81-84ce-3c39db63859f 4. http://consultingblogs.emc.com/jamiethomson/archive/2006/03/14/SSIS_3A00_-Data-flows-or-T_2D00_SQL.aspx 5. http://siddhumehta.blogspot.sg/2010/05/ssis-performance-testing-measurement.html Thanks, Khilit http://www.bigator.com