Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 ssis heavy bulk load

Author  Topic 

zion99
Posting Yak Master

141 Posts

Posted - 2010-06-07 : 00:27:33
Hi,

I need to load some 380 Million records through SSIS. everytime i try to do so, it just fails. I dont think there is any limitation with SSIS regarding the no. of records. Also, I have increased the timeout to 10000 seconds but this has not helped.

Has anybody loaded such a huge data successfully in one go? If yes please let me know the steps taken for the same.
Thanks.
   

- Advertisement -