<div>
I strongly recommend to read this article carefully, and raise up performance of your data flow with it:<br />
<a href="http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/" rel="ugc">http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/</a><br />

</div>


I strongly recommend to read this article carefully, and raise up performance of your data flow with it:
http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ [http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/]


<div>
How long and when is the insert running? Common problem could be:<br />
1. Any other processes running on source/destination box at the same time? Backup perhaps?<br />
2. Doeas destination DB have enough free space? Could be that after first 40 mil. rows, DB space increasing causes additional IO.<br />
3. Network load is fine?<br />

</div>


How long and when is the insert running? Common problem could be:
1. Any other processes running on source/destination box at the same time? Backup perhaps?
2. Doeas destination DB have enough free space? Could be that after first 40 mil. rows, DB space increasing causes additional IO.
3. Network load is fine?


<div>
<div class="content wysiwyg-content">
We have a package where it copies about 100 million records each day from the OLTP to the OLAP enviornment.We are using OLDEDB Destination with fast load to do this.It works ok till 40 million and after that it slows down drastically and almost stalled at somepoint.<br />
Is there anything that Im missing.<br />
?<br />
Currently I have row commit size to infinite and row per batch size to 1 million.<br />
Thanks
</div>
</div>


We have a package where it copies about 100 million records each day from the OLTP to the OLAP enviornment.We are using OLDEDB Destination with fast load to do this.It works ok till 40 million and after that it slows down drastically and almost stalled at somepoint.
Is there anything that Im missing.
?
Currently I have row commit size to infinite and row per batch size to 1 million.
Thanks

BULK INSERT GETTING SLOW FROM SSIS 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.