Good day, I need help please. In my source I read about 4mil records in a matter of seconds But Importing the Output to the Same Table takes about an 1 hour to update. My Source Read is the Same Table to which i'm Importing, Updateing,Deleting Importing: Table Lock & Check Constraints are checked Please any ideas & suggestions will be great. Thank You

try with FAST LOAD to increase performance in oledb destination. also UNCHECK the constraints to raise performance. I strongly recommend to read this greate article on data flow tuning: http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ http://www.rad.pasfu.com

How are you updating the table?Nitesh Rai- Please mark the post as answered if it answers your question

Thank You for Assisting. Reza Raad - i will try as soon as the task completes & will give feed back. Nitesh Rai - I'm using an Exucute SQL Task fr Update & Delete Update is fine as it has been optimized to with an inner join, no nolock & on indexes (SQL Forum assisted) Delete is a simple - Delete from table where type = 'TEST'

Hi, OLEDB destination was on Fast Load & I unchecked the Check Constraints and the Loading/Importing is faster. Thank You