dhanasekar.palani (1/28/2009)
I have a main table which has 55 million rows..I am populating a staging table from the main table with the conditions as from date to date...I wrote this staging table pouplation in a stored procedure and I called the stored Procedure in the integration services..But it is taking almost 40 minutes to complete the execution of the prcoedure.. this main table is indexed. Can any one give some idea how to reduce the execution of the procedure.Is there any way that I can put in the integration services so that the insertion to staging table is much faster....Please advise.
Do you know how many rows you have in the staging table as a result of the insertion? Is the staging table indexed too? Did you check the execution plan for the query you are running?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
